Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 279,658 members
  • 10,791 online
  • 2,052,264 posts
  • 155,129 Solutions
Announcements
Congratulations to the new Qlik Luminary and Partner Ambassador class! Meet them here

Welcome to Qlik Community

Recent Discussions

  • forum

    App Development

    Current year vs previous year cumulative sales

    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 ... Show More

    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:

    andrelfg_0-1786559771694.png

     

    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.

     

    Show Less
  • forum

    Visualization and Usability

    Qlik Sense sessions timing out too quickly during scripting/visualization

    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 i... Show More

    Hi everyone,

    SKai_0-1789444240231.png

    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!

    Show Less
  • forum

    Qlik Replicate

    We have set Data format to CSV, but we are seeing data loss and date is missing

    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 i... Show More

    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

    Convert data type

    Transformation Scope

    Schema name is like: % Table name is like: % Column name is like: % Data type is: DATE

    Transformation Action

    Set target data type to: STRING(40) Set target sub data type to: Regular

    2. 
    Convert data type
    Transformation Scope
    Schema name is like: % Table name is like: % Column name is like: % Data type is: DATETIME
    Transformation Action
    Set target data type to: STRING(40) Set target sub data type to: Regular

    while applying this we are getting date like this 
    0003-00-00 00:96:66.000000


    Qlik Replicate 



    Show Less
  • forum

    App Development

    Qliksense 'Skip to Content' Button not behaving as expected

    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 '... Show More

    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).

     

    ol_dev_0-1789420249149.png

    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. 

    ol_dev_1-1789420341916.png

    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? 

    Show Less
  • forum

    App Development

    Deployment and Development Process in Qlik Cloud SaaS

    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... Show More

    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

    Show Less
  • forum

    Connectivity & Data Prep

    Salesforce OAuth

    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,... Show More

    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.

    Show Less
  • forum

    Talend Studio

    API job launched on Talend Remote engine is not reachable even from the local ma...

    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 ... Show More

    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

    Show Less
  • forum

    Water Cooler

    High Five - September 2026, André Hamon

      Featured Member · September 2026 Meet André, our September Featured Member     This month, all eyes are on André, whose journey from New Zealand's... Show More
     
    Featured Member · September 2026

    Meet André, our September Featured Member

     

    Screenshot 2026-09-02 160957.png

     

    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, André!

    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!

    @AndréH 

    Show Less
  • forum

    App Development

    [ARTICLE] How to identify duplicated fields in Qlik Cloud ?

    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 duplicat... Show More

    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! 🚀

     

    Screenshot_1.png

     

    Show Less
  • forum

    App Development

    How to hide data lineage &amp; QVD info in the "Show Details" menu in Qlik Sense Clo...

    When using native chart descriptions or the "Show details" option, users can view object dependencies and data lineage summary. This exposes internal ... Show More

    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.

    muratmert41_0-1789389665590.png

    then

     

    muratmert41_1-1789389699146.png

    This works fine so far, but when users click the button, it exposes a lot of metadata such as QVD names. Like this:

    muratmert41_2-1789389926848.png

    If you want to show the source lineage, click on the source:

    muratmert41_3-1789390021902.png

     

    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?

     

    Show Less
Leaderboard

Qlik community MVPs

Qlik Community MVPs — trusted experts driving collaboration, learning, and innovation.

mvp-banner-side-image