Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
rammuthiah
Creator III
Creator III

Mismatch Table vs Extracted from Table Qlik Sense

I have derived a logic and got a count in a straight table. But after extracting the same table to excel, the result differs from the original.

For eg.

I have the count as Total in straight table is 359, After extracting and count the rows, it is 358. I don't know how it works and checked for the values. 

Labels (2)
3 Replies
eduardo_dimperio
Specialist II
Specialist II

Hi,

You cold use a table with more than 1 fied like  Country,Population(e.g) and export to check the SUM field by Field. My guess is you have some duplicate value.

rammuthiah
Creator III
Creator III
Author

After removing the duplicates, I found less no. in straight table. But more in KPI

eduardo_dimperio
Specialist II
Specialist II

Could you please share your xls?