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,283 members
  • 8,942 online
  • 2,045,751 posts
  • 154,248 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

    App Development

    Text values of datamodel dates is not getting link to dual field of date

    Hi Folks,Previously have raised one thread regarding linking of existing dates (Text format) with Dual dates(Num) but i haven't found any solution for... Show More

    Hi Folks,

    Previously have raised one thread regarding linking of existing dates (Text format) with Dual dates(Num) but i haven't found any solution for it.

    Reposting it here :

    I have recenlty created the date field using Dual to show the dates in descending order in filter pane and selection tool both and its working well.

    Dual(Date1,-1*Date1) giving result 2025/10

    While i tried to incorporate this changes into my existing dates i.e Date which is also holding dates in 2025/10 format but in Text format its not working.

    Let say i wanted to show YTD and Rolling 12 months data when clicking on action button.Its wokring fine and getting associated and selecting with green color.

    R12 Logic:

    =year(addmonths(TODAY(),-2))&'/'&if(num(month(addmonths(TODAY(),-2)))<10,'0','')&num(month(addmonths(TODAY(),-2)))&';' &year(addmonths(TODAY(),-3))&'/'&if(num(month(addmonths(TODAY(),-3)))<10,'0','')&num(month(addmonths(TODAY(),-3)))&';' &year(addmonths(TODAY(),-4))&'/'&if(num(month(addmonths(TODAY(),-4)))<10,'0','')&num(month(addmonths(TODAY(),-4)))&';' &year(addmonths(TODAY(),-5))&'/'&if(num(month(addmonths(TODAY(),-5)))<10,'0','')&num(month(addmonths(TODAY(),-5)))&';' &year(addmonths(TODAY(),-6))&'/'&if(num(month(addmonths(TODAY(),-6)))<10,'0','')&num(month(addmonths(TODAY(),-6)))&';' &year(addmonths(TODAY(),-7))&'/'&if(num(month(addmonths(TODAY(),-7)))<10,'0','')&num(month(addmonths(TODAY(),-7)))&';' &year(addmonths(TODAY(),-8))&'/'&if(num(month(addmonths(TODAY(),-8)))<10,'0','')&num(month(addmonths(TODAY(),-8)))&';' &year(addmonths(TODAY(),-9))&'/'&if(num(month(addmonths(TODAY(),-9)))<10,'0','')&num(month(addmonths(TODAY(),-9)))&';' &year(addmonths(TODAY(),-10))&'/'&if(num(month(addmonths(TODAY(),-10)))<10,'0','')&num(month(addmonths(TODAY(),-10)))&';' &year(addmonths(TODAY(),-11))&'/'&if(num(month(addmonths(TODAY(),-11)))<10,'0','')&num(month(addmonths(TODAY(),-11)))&';' &year(addmonths(TODAY(),-12))&'/'&if(num(month(addmonths(TODAY(),-12)))<10,'0','')&num(month(addmonths(TODAY(),-12)))&';' &year(addmonths(TODAY(),-13))&'/'&if(num(month(addmonths(TODAY(),-13)))<10,'0','')&num(month(addmonths(TODAY(),-13)))

    E.g 2025/10;2025/09;2025/08;...2024/11

     

    Karim_Khan_0-1762862681081.png

     

    Karim_Khan_1-1762862681085.png

     

     

    Show Less
  • forum

    Water Cooler

    Your Friday Fix: Mike Tarallo Live!

    Mike Tarallo is back with another Friday livestream — and it’s a good one! He’ll be showing different ways to access and prep your data in Qlik Cloud ... Show More

    Mike Tarallo is back with another Friday livestream — and it’s a good one! He’ll be showing different ways to access and prep your data in Qlik Cloud using tools like the Data Load Editor, Data Catalog, Table Recipes, and more.

    Catch all the details and jump into the thread here!

    Show Less
  • 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

    App Development

    How can I resolve this issue

    Hello I have the following table:I have selected the above project names;the expression is sum(amount)now total amount is 35.79 which is correctbut in... Show More

    Hello I have the following table:

    ali_hijazi_1-1763102136605.png

    I have selected the above project names;

    the expression is sum(amount)
    now total amount is 35.79 which is correct
    but in the expression I want to eliminate the projects whose parent_project_pfolio_1_id = 1 and pfolio_level_id = 18
    so the last row shouldn't be calculated and thus the total should be 34.73 since the last row shouldn't be counted
    so I wrote the below expression:

    sum(

    {$-<parent_project_pfolio_id_id = 1, pfolio_level_id=18>}

    amount)
    and I got the following result:

    ali_hijazi_2-1763102635778.png

    the total is correct however the results came under null scenario type and null year
    but if I exclude the SUPPORT-BSRM_BSM project I get the fine result:

    ali_hijazi_3-1763102733201.png
    so how can I get the correct result when the project to be excluded is in the current selections set of data?
    why when that project is available the other projects to be included come under null year and null scenario?

    knowing that all the fields except the year and scenario are in the project table (dimension) linked to fact table via prjh_key and the year is part of the calendar table linked to fact table via the month_key and the scenario is part of the scenario table linked to fact table via scenario_key

     

    kindly advise

     

     

    Show Less
  • forum

    App Development

    Exporting a table to Excel

    I am trying to export information to excel and click format when exporting. When I open the Excel file I get a message to say: We found a problem with... Show More

    I am trying to export information to excel and click format when exporting. When I open the Excel file I get a message to say: We found a problem with some content in Filename.xlsx. Do you want to try to recover as much as we can?

    The error meaage is as follows-

    <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
    <recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><logFileName>error913480_01.xml</logFileName><summary>Errors were detected in file 'C:\Users\braham.edwards\Downloads\Comms to Pay - Month 1(zMKPSJ) (1).xlsx'
    </summary><repairedRecords><repairedRecord>Repaired Records: Format from /xl/styles.xml part (Styles)</repairedRecord></repairedRecords></recoveryLog>

    How do I find out what column is causing the problem?

    Show Less
  • forum

    Data Movement & Streaming

    Can I send a message to Whatsapp through Qlik Automation?

    Hi, I have searched for a connector or any other way to send a message stating a simple amount from a master measure to Whatsapp from Qlik Automation.... Show More

    Hi,

    I have searched for a connector or any other way to send a message stating a simple amount from a master measure to Whatsapp from Qlik Automation.

    I know this is possible with Microsoft Teams (I have done this before).

    Is there a way to do the same thing with Whatsapp through a connector or other method?

    Thanks!

    Show Less
  • forum

    QlikView App Dev

    Qlikview % of Total Ranked

    I have my list of data (Branch, Item, Customer) ranked in a pivot table based on the field "ext_price_gross", which is working just fine.  What I'm lo... Show More

    I have my list of data (Branch, Item, Customer) ranked in a pivot table based on the field "ext_price_gross", which is working just fine.  What I'm looking to do is to then give me a percentile based on these rankings.  I'm figuring that I have to do something like:

    1 - ((ranking value) / (max of total ranking)

    If my Ranking Value that works is: Rank(sum(ext_price_gross),3,1)

    then how do I get the max of the rankings?

    If I have 100 things ranked, the 5th ranked thing should return 95% (1 - (5/100))

    Thank you.

     

    Show Less
  • forum

    Integration, Extension & APIs

    How to apply user filters in Qlik Narrative API responses?

    I’ve been working with the Qlik APIs for narrative responses and noticed something I can’t resolve.Current API in use: /api/v1/questions/actions/askDo... Show More

    I’ve been working with the Qlik APIs for narrative responses and noticed something I can’t resolve.

    • Current API in use: /api/v1/questions/actions/ask
      Docs

    • Previously used API: /api/v1/nl/query
      Docs

    → These endpoint doesn’t seem to provide an option to pass filters.

    The issue is that I want the narrative response to reflect user-applied filters, but currently the APIs only return unfiltered data values.

     

    Show Less
  • forum

    App Development

    sset analysis help

    HelloI'm working on a dashboard with huge dataI have to calculate the man-days is there a difference between the below syntax?{<condition_1>-(<conditi... Show More

    Hello
    I'm working on a dashboard with huge data
    I have to calculate the man-days 
    is there a difference between the below syntax?
    {<condition_1>-(<condition2>+<condition3>)}
    sum(mandays)

    and 
    {<condition_1>}
    sum(mandays)

    -

    {<condition2>}

    sum(mandays)

    -

    {<condition3>}
    sum(Mandays)

     

     

    Show Less
  • forum

    App Development

    Help in expression

    HelloI have a pivot table with several expressionsI will show you 2 expressions 1 and 2 written in two different ways but they return the same correct... Show More

    Hello
    I have a pivot table with several expressions
    I will show you 2 expressions 1 and 2 written in two different ways but they return the same correct result

    expression 1 is not distributed on any dimension
    while expression 2 is distributed on any dimension

    ali_hijazi_0-1763064114002.png

    but expression 2 is very slow when used with the remaining expressions in the pivot table
    while expression 1 is much faster

    Expression1:
    {
    $
    -<[Parent PRoject Portfolio Level 1 ID]={1},[Portfolio Level 1 ID]={18}>
    -<[Parent PRoject Portfolio Level 1 ID]={1},[Portfolio Level 3 ID]={37}>
    }
    sum(SPENT_MANDAYS)

    Expression 2:

    (
    sum(SPENT_MANDAYS)
    -
    {<[Parent PRoject Portfolio Level 1 ID]={1},[Portfolio Level 1 ID]={18}>}
    sum(SPENT_MANDAYS)
    -
    {<[Parent PRoject Portfolio Level 1 ID]={1},[Portfolio Level 3 ID]={37}>}
    sum(SPENT_MANDAYS)
    )

     

    kindly advise on why expression 1 is alwys under null scenario type

    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.