Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
magicalqlik
Contributor
Contributor

KPI sum value is different than the pivot table

I have a data set with a column name as Gross Sale and another one with its corresponding client.

From the pivot table, using SUM([Order Amount]) as the expression and i am using the same expression SUM([Order Amount]) for the KPI too.

But the numbers are different, KPI has lower gross sale amount compared to the pivot table.

The counts for these 2 differed too, KPI is calculating using Count([Order Amount]) = 204 while pivot table gives 208 as count.

 

Labels (1)
2 Replies
zwilson_borg
Contributor III
Contributor III

Are you suppressing null values in the pivot table? For example, if you are grouping by a dimension with some null values, they will be excluded.

MayilVahanan

HI @magicalqlik 

Its looks like one of the dimension in the pivot table cause duplicate. 

For testing purpose, you can remove all the dim & add one by one to find which field cause duplicate.

Hope it helps.

Thanks & Regards,
Mayil Vahanan R