Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a simple pivot table which summarize the sum of sales for each customer grouped by Quarter and Year (See attached file).
I want to change the data so instead of the sum of sales for each quarter it will show in each quarter the sum of sales for the previous 5 quarters .
For example, in the attached table - the date for Q4/2025 shows 20 and I want it to show 270 which is the sum of the previous 5 quarters.
Thanks
Hello,
I should mention that I am new to using automation. Basically, I have four script apps (A, B, C, D) that extract data from the database and simply write the qvds. These four applications have been included in four separate automations, each triggered from database by a Webbook URL POST, as the data in the database is updated at different times. So far, so good, except that if I want to create another automation that has to start at the end of the reload of apps A and B to update app E, I can't. I tried using a Webhook in the start block to trigger app E when A,B are updated, but I see that they do not go to AND but to OR, so every time app A or B finishes, they trigger the automation that updates E. Is it possible that I was able to manage these dependencies easily in QMC and here it is not possible to do so? How can I manage the start of an automation upon completion of two or more previous apps?
Thank you
Hi i got a pivot table with 2 dimensions (rundate_placement3, rundate_placement3details) and a lot of dates (rundate_Date). i want just show the sum of costPerRundate_NettoNetto for the day (can be 1 week, a month or any date) following today.. it doesnt work. do yo usee why=
Sum({< rundate_Date = {"$(=(Aggr(Min({<rundate_Date = {">=$(=Today())"}>} rundate_Date), rundate_Placement3, rundate_Placement3Details)))"} >}
costPerRundate_NettoNetto
)
Bom dia !!!!
Tem um cadastro de pemanência onde cada usuario permanece por um período Data Inicio e Fim, e preciso criar um calendário pra saber em quais datas eles permaneceu e suas comperências ANO/MÊS 202003 até 202104.
Sendo que no cadastro tenho seu código apenas com as data de início e Fim.
Exemplo:
Cód. | Data Inicio | Data Fim
1 | 01/03/2020 | 31/04/2021
Ou seja o Cód. 1 esta nas competências 202003, 202004, 202005,.... até 202104, quando filtrar qualquer dessas competências o Cód. 1 estará relacionado.
Att..
I want to create two date variables. First one, which is the maximum date based on a condition location=Dallas and another variable which is 12 months before the max date. How do I do it on this?
Hello Everyone,
Using SSIS I'm noticing that the Microsoft Software seems to include directly a way to connect to an OLE DB Azure MS SQL.
I'm not finding a way to work with OLE DB with Talend.
Do you have an idea how I could manage that ?
Respectfully,
Waffle
Good afternoon. I need to build a chart that displays the cumulative sum of sales records based on a selected period. I have three filters available: year, month, and frequency (monthly, quarterly, and yearly).
When selecting a specific period, for example July 2025 (202507), the chart should display the previous periods according to the selected frequency:
Quarterly: the periods 202407, 202410, 202501, 202504, and 202507 should be displayed, where each point represents the cumulative sum of records for the corresponding quarter.
Yearly: the periods 202107, 202207, 202307, 202407, and 202507 should be displayed, accumulating the records from the 12 months of each year.
Monthly: only the five months prior to the selected period should be displayed.
The current issue is that, when generating the chart, only the individual values for each period are shown, rather than the cumulative total that includes the corresponding previous months.
Thanks!
This release includes several UI/UX improvements and new features, including:
Some bugs have also been fixed.
Hi everyone,
I recently upgraded our Qlik Sense Enterprise on Windows from Nov 2024 to Nov 2025 Patch2. Everything seemed fine until I noticed that the Reload Content Monitor task started failing consistently.
Upon checking the script log, I identified the error occurs during the Connect To 'monitor_apps_REST_app' step:
Error: Unexpected character encountered while parsing value: <. Path '', line 0, position 0.
I have already searched the community and tried the following official support solutions:
1. Create a second Virtual Proxy allowing Windows authentication: https://community.qlik.com/t5/Official-Support-Articles/Qlik-Sense-Enterprise-on-Windows-Unexpected-character/ta-p/1714588
2. How to configure Certificate Authentication for Qlik Sense Monitoring Applications: https://community.qlik.com/t5/Official-Support-Articles/How-to-configure-Certificate-Authentication-for-Qlik-Sense/ta-p/1799913
The confusing part, While the Content Monitor fails, both the License Monitor and Operations Monitor are reloading successfully without any issues. Since these apps typically rely on similar REST connection logic, I am unsure why only the Content Monitor is struggling.
Has anyone encountered this? Any suggestions on what else I should check would be greatly appreciated.
Thank you in advance!
FREE TRIAL
Data has stories to tell—let Qlik help you hear them. Start your FREE TRIAL today!
Become a data legend in a flash. Workshop registration is open and spots are filling fast. Get a special $500 savings now until February 14, 11:59PM ET. Use code FLASH2026
See why Qlik was named a Leader in the 2025 Gartner® Magic Quadrant™ for Data Integration Tool.
Trends 2026 Alert! Plug into this rewired framework for driving ROI from AI.
Learn why legacy data platforms can’t meet today’s AI and analytics demands and how Qlik provides a modern, independent, future-ready alternative.
Solve the real-world need for real-time data with Change Data Capture (CDC). What is CDC and how to master it?
Your journey awaits! Join us by Logging in and let the adventure begin.
Qlik turns raw data into valuable learning experiences, empowering both students and faculty at TTUHSC.
MillerKnoll partnered with Qlik Talend® data solutions to unify data across its diverse systems, accelerating critical processes and nearly eliminating data integration issues organization-wide.
Migration to Qlik Cloud Analytics optimizes analytics applications within months.
With Qlik Cloud Analytics, Rexel boosts performance by enabling self-service analysis, reducing prep time, and giving 3,000 users access to trusted insights.
Join one of our Location and Language groups. Find one that suits you today!
Únete a la conversación con usuarios de Qlik en todo México: comparte ideas, haz preguntas y conéctate en español.
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Connectez-vous avec des utilisateurs francophones de Qlik pour collaborer, poser des questions et partager des idées.
The Qlik Product Recap showcases the newest features with quick demos and shareable resources to help you stay current?
You can test-drive Qlik for free? Try Qlik Talend Cloud to integrate and clean data without code, or explore Qlik Cloud Analytics to create AI-powered visualizations and uncover insights hands-on.
Salesforce’s acquisition of Informatica could put your flexibility on hold? Qlik makes it easy to keep your data initiatives moving forward.
You can move beyond batch processing and harness real-time data to power AI and faster decisions? Discover how in our new eBook, Mastering Change Data Capture.