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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikuser22
Creator II
Creator II

KPI not matching straight table

Hi

I have a KPI for calculating number of orders. 

=Count ({$<Status={Finished}>} ID) - This KPI gives 25900 

 

I am creating a table with 28 columns and no filter applied. But if I download the table into excel I can see only 20875 records. I have a dimension called status where I am using the expression if(Status = 'Finished', 'Completed'). I am not writing any expression in other dimensions. 

 

I want to know where I am losing around 5000 records.

 

Please do help.

 

Thanks. 

 

Labels (1)
10 Replies
qlikuser22
Creator II
Creator II
Author

Perfect. I understood that all the dimensions has to be added to match with KPI value. 

 

Thanks.