Mismatch Table vs Extracted from Table Qlik Sense

[rammuthiah]

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. 

[eduardo_dimperio]

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]

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

[eduardo_dimperio]

Could you please share your xls?