There are times when the query results don't match the actual data being loaded into the dashboard. This inconsistency has been affecting the accuracy of the reports. Please see below screenshot for reference:

Query Results: 144,737

Total Number of Rows: 130,495

Do you have any idea how to fully load the 144,737 rows?

We’re excited to kick off a new chapter in our advocacy story — the Qlik Luminary & Partner Ambassador Affiliate Program. This new initiative gives past Luminaries and Ambassadors a way to stay connected and keep making an impact. It celebrates those who continue to champion Qlik in their organizations and beyond — long after their official program year ends.  

The Affiliate Program gives these leaders an ongoing platform to stay involved, share their expertise, and keep inspiring others across the Qlik community.  

Meet our Affiliates!  
We’re proud to recognize these incredible individuals, innovators, thought leaders, and trusted voices, who are extending the impact of our advocacy programs and helping us grow an even stronger, more connected Qlik network.  

Meet this incredible community of leaders and innovators below:  

Please take a moment to leave a comment and/or like! Are you a former Luminary or Partner Ambassador who would like to stay connected to Qlik as an Affiliate? Contact us at QlikLuminaryProgram@qlik.com or QlikPartnerAmbassadors@qlik.com.  

Hey,

I want to show the number of  items sold for a certain category, by store.
The measure is simple - Sum(Qty).
My report should include all the stores.

The problem is some stores didn't sell any items from the relevant category,
so I don't see them at all in the report (table or pivot).

For example:
Store 1 - Sold 3 items on Jan and 2 items on Feb. Total of 5.
Store 2 - Sold 2 item on Jan and 1 item on Feb but this item was returned. Total of 2.
Store 3 - Didn't sell any items in Jan, and sold 1 item in Feb.
So in total:
Store 1 - Jan 3, Feb 2, Total 5.
Store 2 - Jan 2, Feb 0, Total 2.
Store 3 - Jan Null(?), Feb 1, Total 1.
We will see the problem if we select only for Jan - Store 3 will not appear in the report.

Enabling the 'show zero values' option doesn't work, using functions like Alt() or conditions in the measure (like If(Len<1, 0,..)) doesn't help either.

I'd appreciate your help.

Hi,

I'm trying to Create a Big Data Batch Job on my Talend Studio 8 (2025)

Following this steps : 

https://help.qlik.com/talend/en-US/studio-user-guide/8.0-R2025-02/creating-spark-job?ver=22

But i dont have this option when i Right-click the Job Designs node and in the contextual menu.

How to configure my studio in order to have access to that ?

Thanks

Hello,

I am desperatly trying to get a hold of the recommended courses/ learning plans to correctly prepare for the talend data integration certified Developer exam but I am having no luck with it. 

The customer care is unable o help me and keep redirecting me to the "send a request" form through which I am not having any responses. 

Can someone help please. Thanks in advance.

Hi everyone,

I'm addressing a specific requirement from one of my stake holders where they need multidimensional labels, I would highly appreciate if anyone can help me assist how we can achieve in qlik, please see the image attached for reference.

thank you 

Hey all.  I am needing to compare 2 date fields to get average days lapsed in between separate services.  Example - patient comes in on 3/2/2025 (1st Service Date) for intake (1st Service Code), and then comes in on 3/8/2025 (2nd Service Date) for follow up (2nd Service Code).  I am wanting (1st Service Code) to filter out results with only that code, and then then display the date of that service.  Then I am wanting the 2nd Service Code column to only show when the follow up code happened for that same patient and display that date.  All columns would be based on distinct patient id numbers.  Screenshot below of what I have currently, just not sure how to build the dependency.  Thanks for your help.

From Newbie to Champion, there’s an exciting path to ranking up in the community.

Wondering how many people have earned the rarest badges?
Want to see which rank you're close to obtaining?

Check out the full ranking breakdown and have a look at all 72 badges in the PDF attached!

Im Getting this error when I try upgrade PostgreSQL stand alone with the 2025 May release; 2025-07-09 17:04:08.892 +02:00 [ERR] Error! UnhandledException caught: Error! Could not parse existing PostgreSQL service parameter: ""F:\Qlik\Program files\Repository\PostgreSQL\14.8\bin\pg_ctl.exe"" runservice -N "postgresql-x64-14" -D "C:\ProgramData\Qlik\Sense\Repository\PostgreSQL\14.8" -w! Registry entry exists but file does not exist on disk in path: "F
2025-07-09 17:04:08.902 +02:00 [ERR] UnhandledException StackTrace: at Qlik.PostgreSQL.Installer.Utility.Database.PostgreSqlDetector.ParseProductVersionFromExeFileInfo(String postgreSqlServiceParameter)
at Qlik.PostgreSQL.Installer.Utility.Database.PostgreSqlDetector.GetInstalledDatabaseVersionFromServiceRegistryEntry()
at Qlik.PostgreSQL.Installer.InstallRunner.Initialize()
at Qlik.PostgreSQL.Installer.Program.Run()
at Qlik.PostgreSQL.Installer.Program.Main(String[] args)
2025-07-09 17:04:08.904 +02:00 [ERR] Runtime terminating: true

Any help on the issue?