Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
rammuthiah
Contributor 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. 

3 Replies
eduardo_dimperio
Valued Contributor II

Re: Mismatch Table vs Extracted from Table Qlik Sense

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
Contributor II

Re: Mismatch Table vs Extracted from Table Qlik Sense

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

eduardo_dimperio
Valued Contributor II

Re: Mismatch Table vs Extracted from Table Qlik Sense

Could you please share your xls?