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: 
  • 264,596 members
  • 9,785 online
  • 2,045,977 posts
  • 154,268 Solutions
Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!

Welcome to Qlik Community

Trending Forums

Recent Discussions

  • forum

    Management & Governance

    NEW! Content Monitor for Qlik Sense Enterprise on Windows

    The new Content Monitor loads from the APIs and logs to present key metrics on the content, configuration, and usage of your platform, allowing admini... Show More

    The new Content Monitor loads from the APIs and logs to present key metrics on the content, configuration, and usage of your platform, allowing administrators to understand the evolution and origin of specific behaviors of the platform.

    • Basic information can be found in Content Monitor | help.qlik.com  
    • Each sheet in the Content Monitor includes an About text box to describe its content. 

    This new monitoring app comes pre-installed with the latest version (November 2025 onwards) of Qlik Sense Enterprise on Windows.

    If you are running previous versions of Qlik Sense Enterprise on Windows, the Content Monitor is also available on Qlik's Downloads page here: Content Monitor (download page) - note, this must be manually installed and a weekly reload is recommended.

    Show Less
  • forum

    Water Cooler

    Underwriting Years

    Hi Community,Really need your help with a coding challenge I'm facing. I'm a coding novice, but need assistance coding the following in the loadscript... Show More

    Hi Community,

    Really need your help with a coding challenge I'm facing. I'm a coding novice, but need assistance coding the following in the loadscript:

    I need to calculate a sequential underwriting year and the start and end dates of an underwriting year by extrapolating from the original policy inception date. 

    As an example, if a client incepted coverage on 01 August 2020 (ie original policy inception date), the underwriting years would be calculated as follows:

    1 > 01 Aug 2020 to 31 Jul 2021

    2 > 01 Aug 2021 to 31 Jul 2022

    3 > 01 Aug 2022 to 31 Jul 2023

    And so forth. 

    Currently, I only avail of the original inception date and the assumption that all policy periods are 12 months. 

    Help! Please 🙂 

    Show Less
  • forum

    Visualization and Usability

    Incorrect total percentage in Table chart

    Dear Experts, I have a column Completion in table with some calculation. It is showing correct individual values but the total is wrong.  Archival dat... Show More

    Dear Experts,

     

    I have a column Completion in table with some calculation. It is showing correct individual values but the total is wrong. 

    Screenshot 2025-11-19 at 12.20.10 PM.png

    Archival data #DOC = count( {$<SET={'Archival data'}>}distinct DOCNO)

    Current data #DOC = count({$<SET={'Current data'}>}distinct DOCNO)

     

    Completion = count({$<SET={'Current data'}>}distinct DOCNO) / count( {$<SET={'Archival data'}>}distinct DOCNO)

    Completion column number formatting is Number 12.3%

     

    The correct Total Completion % should be 62798 / 71722 = 0.8755 or 87.6%

     

    Regards,

    Sarah Azizan

    Show Less
  • forum

    Qlik NPrinting

    On-Demand reporting control is not supported in this environment

    Hi guys,I've updated my Qliksense-Environment to November2025 und my NPrinting-Version is February 2024 IR.After th Qliksense update I get following e... Show More

    Hi guys,

    I've updated my Qliksense-Environment to November2025 und my NPrinting-Version is February 2024 IR.

    After th Qliksense update I get following error by clicking "onDemand-Report":

    "On-Demand reporting control is not supported in this environment"

     

    Is the solution to update my NPrinting-Version?

    Regards
    Chris

     

    Show Less
  • forum

    Reporting Service & Alerting

    Pixel perfect report not sent

    Hi, We’re experiencing an issue with a Qlik SaaS in app Pixel Perfect report that fails to send to a specific user. The same report is delivered succe... Show More

    Hi,

     

    We’re experiencing an issue with a Qlik SaaS in app Pixel Perfect report that fails to send to a specific user. The same report is delivered successfully to all other recipients, and the affected user also receives other (Excel-based) reports generated from the same Qlik application.

    The app uses Section Access, but the user has full access to all data. In the Qlik event log, every step completes normally except for the final step com.qlik.transport-response.email.sent, which is never triggered. As a result, no corresponding email appears in the Exchange logs.

    Any ideas?

    Regards.

    Show Less
  • forum

    App Development

    certain records will still show in the table even they don't meet the filter cri...

    I need to build a table where holds records of products. and I will provide filter for user to filter on various attributes. but there is some records... Show More

    I need to build a table where holds records of products. and I will provide filter for user to filter on various attributes. but there is some records I wish to show in the table regardless whether it meets the criteria of those filters applied by the users. just wondering is there a way to achieve this

    Show Less
  • forum

    App Development

    Ranking not work correctly

    I am building a straight table to show top 10 orders, and also includes their information (such as product, customer). I've tried these 2 methods but ... Show More

    I am building a straight table to show top 10 orders, and also includes their information (such as product, customer).

    I've tried these 2 methods but both of them did not get the correct top orders.

    1. Click the order_number and limit to top 10.

    2. Use Ranking expression.

    The formula I used:

    =AGGR(

    RANK(

    Sum(

    {<

                    BUSINESS={'A', 'C', 'D'},

        YEAR={$(=YEAR(TODAY()))},

        MTD_FLAG={'Y'}

    >}

    ORDER_AMOUNT

    )

    ,0,1),

    BUSINESS,

    ORDER_NUMBER

    )

     

     

    Show Less
  • forum

    App Development

    Week 53 Comparisons

    Hi all,I wanted to check in to see what other companies do with last year comparisons with week 53?Do you adjust last year comparisons in your apps to... Show More

    Hi all,

    I wanted to check in to see what other companies do with last year comparisons with week 53?

    Do you adjust last year comparisons in your apps to compare for example: 2025 week 53 with 2025 week 1? 

    Or do you ignore week 53 completely?

     

    This causes us a bit of pain every 5 years with shifting logic in our apps so I wanted to double check how other people do this?

    Many thanks

    Show Less
  • forum

    App Development

    Set analysis using dimensions within table

    I want a table that has dimension: WeekAnd I want measures using set analysis that calculates This Year Sales and Last Week Sales (where the set analy... Show More

    I want a table that has dimension: Week

    And I want measures using set analysis that calculates This Year Sales and Last Week Sales (where the set analysis will pick up the previous week).

    However, this will then create 2 lines.

    For example if it is week 46 2025, then it will have 2 lines showing Week = 45 and 46, with TY Sales populated on line with 46, and LW Sales populated on line with 45 on it.

    WeekTY SalesLW Sales
    450100
    462000

     

    I have tried set analysis = Sum({<Year={2024},Week={45}>}[Sales Value Gross])

    And also an aggregated expression, but nothing will work.

    Any advice would be great, thanks in advance!

    Show Less
  • forum

    App Development

    DATA Connections cannot load successfully when closing external internet server ...

    As the picture shows, when IT colleague opened the external internet server, I cannot load data connection successfully, only when he closed the exter... Show More

    HelloHMC_0-1763350614970.png

    As the picture shows, when IT colleague opened the external internet server, I cannot load data connection successfully, only when he closed the external internet server(just using internal server), I can load data connection.

    For our company, we don't allow to use external internet server in principle.

    So, we want to obtain the tech-support to help us deal with this problem.

    Thanks and best regards!

     

    Show Less

FREE TRIAL

Data has stories to tell—let Qlik help you hear them. Start your FREE TRIAL today!

Leaderboard

Qlik community MVPs

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

mvp-banner-side-image

Customer Story

Catalyst Cloud (Fusion)

Catalyst Cloud developed Fusion, a no-code portal that integrates with existing Qlik licenses to deliver critical insights across the organization. The results? Time savings, transparency, scalability to expand, and increased adoption.

Customer Story

Catalyst Cloud (Coeus SEP)

Catalyst Cloud developed Coeus SEP, a Qlik‑based platform for sharing supply chain data with suppliers.

Customer Story

Instant Answers Empower Thousands of Users

Billion-dollar organization delivers quality service and consistency at scale with Qlik Answers, powered by Amazon Bedrock.

Customer Story

Empowering Students With Data Skills for Real-World Impact

Thomas More University works with the Qlik Academic Program and EpicData to encourage and inspire students.

Customer Story

Revolutionizing aircraft production through Data Analytics

Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.

Your Place, Your People

Choose a Group

Join one of our Location and Language groups. Find one that suits you today!

Collaborate

Qlik en México

Qlik en México

Únete a la conversación con usuarios de Qlik en todo México: comparte ideas, haz preguntas y conéctate en español.

All are welcome

Hello from Japan

Japan

Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。

Request to join

Parlons Données

Parlons Données

Connectez-vous avec des utilisateurs francophones de Qlik pour collaborer, poser des questions et partager des idées.

open to all

Did you know...

Catch the Latest from Qlik

The Qlik Product Recap showcases the newest features with quick demos and shareable resources to help you stay current?

Did you know...

Qlik Free Trials

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.

Did you know...

Turn change into opportunity

Salesforce’s acquisition of Informatica could put your flexibility on hold? Qlik makes it easy to keep your data initiatives moving forward.

Did you know...

Mastering Change Data Capture

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.