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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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.