Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all, good evening,
I need to compare the cumulative sales between a year and the year before. This for many years stored in my database.
The sales had already been normalized by the month of each year.
This is the expression I created to generate the information for each year:
Aggr(RangeSum(Above(Sum(QTY), 0, RowNo())), [SALES YEAR, [YEAR/MONTH])
| YEAR/MONTH | SALES YEAR | QTY |
| (other year months) | ... | ... |
| 2026/01 | 2024 | 1 |
| 2026/02 | 2024 | 10 |
| 2026/03 | 2024 | 25 |
| 2026/04 | 2024 | 8 |
| 2026/05 | 2024 | 14 |
| ... | ... | ... |
| 2026/01 | 2025 | 0 |
| 2026/02 | 2025 | 3 |
| 2026/03 | 2025 | 12 |
| 2026/04 | 2025 | 11 |
| 2026/05 | 2025 | 7 |
| ... | ... | ... |
| 2026/01 | 2026 | 4 |
| 2026/02 | 2026 | 5 |
| 2026/03 | 2026 | 8 |
| 2026/04 | 2026 | 12 |
| 2026/05 | 2026 | 20 |
And this is the generated graphic:
What I need is to created a new graphic that shows, for each year, the % growth between that year vs its last year, using the same rule (acumulated sales for each month).
I have already tried many solutions here in the topics, but I couldn't get the right result.
For exemple: Aggr(RangeSum(Above(Sum(QTY) / Sum({<[SALES YEAR] = {"$(=Only([SALES YEAR])-1)"}>}QTY), 0, RowNo())), [SALES YEAR, [YEAR/MONTH])
Thanks in advance for any help.
Hi everyone,
Recently I’ve been facing an issue in Qlik Sense where the application keeps offloading while I’m working on scripting or visualizations in a tab. When this happens, all other open tabs need to refresh after not more than 3–5 minutes.
By default, Qlik Sense should allow 30 minutes of user inactivity before an idle session times out and shows the error/reconnection message. However, I’m now seeing the inactivity message after less than 5 minutes, even while actively working.
This behavior is making progress very slow and disrupting my workflow. Previously, the issue only occurred after a longer period of inactivity, but now it happens almost immediately. And, I could reload data without losing activity in other tabs. Now, the moment a reload starts, every other tab becomes inactive right away.
Has anyone else experienced this sudden change in session timeout behavior? Could this be related to server configuration, resource limits, or recent updates? Any guidance on how to troubleshoot or fix this would be greatly appreciated.
Thanks in advance for everyone's help!
So we trying to load data in s3 bucket in CSV format but i can see dates are not getting populated in CSV soo i have applied global rule but than it is changing the date
1 transformation rule
Transformation
Transformation Scope
Transformation Action
Hi,
For Qliksense accessibility mode, there is a 'Skip to Content' when the tab key is pressed, as the screenshot below. We expect that upon pressing 'Enter' or 'Space' key, it will lead us to the first visualization in the current sheet (eg. My Filterpane in the screenshot).
However, this is not how Qliksense behaves. What actually happens instead, is that it opens up the Asset panel and the focus shifted towards the Sheets button at the left panel.
I do not understand, is this the intended behavior of Qliksense? If so, is there a way to bypass this default and instead force 'Skip to Content' button to lead to the first visualization in current sheet? I find this behavior extremely confusing, and our UX/UI designers are not fond of this either. I've seen this button on some websites and they all behave correctly that if you press such a button, it takes you to the first item in the body of the page.
Can someone help?
Hello together,
we moved from onpremise to cloud.
Before we had the "final" apps in streams, when we wanted to work on an already published app, we made 2 duplicates from the published app, one was moved into the archive stream, and we worked with the other one.
After we made our changes, we simply republished the app.
In case there was a mistake, we simply republished the app from the archive stream.
This process is not possible anymore.
so my question is, what is the best practice to do so in the cloud?
thanks
Hi,
I'm using Qlik Sense May 2026 Patch 2. I'm trying to setup the Salesforce data connection using OAuth. (using client ID and client secret) However, when I try to authenticate, I get the following error:-
error=redirect_uri_mismatch&error_description=redirect_uri%20must%20match%20configuration
Anything that I missed? For the environment, I tried "Production" and "My domain", both give me the same error.
Hi,
I've followed the "Deploying API Services" learning module in Qlik learning to setup and deploy an API job on a VM. I've successfully deployed the API job from TMC however I am unable to call the endpoint even from the local machine.
I always receive a 404 not found error.
Here's what I've tried. In the Remote Engine files, I opened "org.ops4j.pax.web.cfg" and checked which ports are listed in that file. I then added this to my URL however it still gives me the 404 not found error.
I am not entirely sure what to check next. I am not very familiar with Talend products so can someone please point me to where I can get started to find out what to do?
Regards,
Mohammed
This month, all eyes are on André, whose journey from New Zealand's insurance industry to the heart of London's data community shows exactly the kind of curiosity and drive that makes a great Qlik Community member. A dedicated Qlik customer for years, André brings real, hands-on experience to every thread he touches, and he's not shy about sharing it. We're thrilled to name him our Featured Member for September 2026!
André spent the last decade working in general insurance in New Zealand, starting out in underwriting before moving into BI and data. Most recently, he worked at Ando Insurance, where he worked across Qlik Cloud, Snowflake, and Salesforce, and embedded AI into BI workflows. While there, André had the opportunity to speak at Qlik Connect in 2024, and in 2025, Ando Insurance was recognized with the Qlik Organizational Transformation award at the Qlik Digital Transformation Awards Australia & New Zealand in Sydney.
“Explaining a set analysis expression, a load script pattern, or an automation block to someone else forces me to properly understand it.”
— André
For André, the Community has always been more than a resource, it's where he's worked through some of his toughest Qlik challenges over the years, usually by finding a thread where someone had already hit the same wall. Now, he pays it forward by answering questions himself, and he says he picks up plenty from other people's answers along the way too.
Outside of Qlik, André loves building things just for the fun of it, from a Raspberry Pi dev server to small apps and even a Qlik extension or two. He's also working on learning French (even after two months living in Lyon), and he's an avid tennis fan.
Thank you for bringing your expertise and generosity to the Qlik Community. Please join us in celebrating André as our September 2026 Featured Member, leave a comment below!
After a long wait, Qlik Cloud has finally introduced a feature that can save a LOT of time for developers! 🙌
When loading data, if a field is duplicated, Qlik now tells you exactly which field is causing the problem. 🎯
Before this update, I had to manually search for the duplicated field — and sometimes there were hundreds of fields to go through. 😩🔎
Now? Qlik simply shows you the exact name of the duplicated field. 💥
Less manual work.
Less frustration.
More time to focus on what really matters: building things. 👨💻⚡
This may look like a small improvement, but for anyone working with large data loads, it’s a BIG deal! 🚀
When using native chart descriptions or the "Show details" option, users can view object dependencies and data lineage summary. This exposes internal metadata, such as QVD file names, database table origins, and field calculations, which we need to keep hidden for security and governance reasons.
then
This works fine so far, but when users click the button, it exposes a lot of metadata such as QVD names. Like this:
If you want to show the source lineage, click on the source:
Questions:
Is there a native way to display chart help text / descriptions while completely suppressing backend lineage details (QVD names, source tables) in the chart UI?
If we restrict the "View lineage" permission at the Security Role / User Default level, does it completely hide the QVD/table lineage inside the chart's details pane for business users?
What is the recommended best practice for this scenario? Are custom popovers (e.g., using a Button + Variable + Text object) or Custom Tooltips the only bulletproof workarounds?
Qlik is a Leader in the IDC Events/Global Events MarketScape: Worldwide Data Intelligence Platform Software 2026 Vendor Assessment
Here’s your agentic AI readiness check. (Got Qlik? You're closer than you think.)
Set your course for six weeks of expert-led sessions on data, analytics, and AI — available on demand.
Built for the builders: Modern data engineering is AI powered — and engineer led.
The pilot-to-production gap is real. From fragmented data to governance gaps Qlik and AWS break down what’s holding your enterprise AI back — and how to solve them.
Your journey awaits! Join us by Logging in and let the adventure begin.