Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

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
Highlighted
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.

Highlighted
Creator II
Creator II

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

Highlighted
Specialist II
Specialist II

Could you please share your xls?