Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

danielco223
New Contributor III

Pivot Table has incorrect Total

Hi, I have a pivot table that is displaying the incorrect total. in a straight table, it is displaying as below:

5-22-2018 3-55-35 PM.jpg

but in a pivot, it shows up like this

5-22-2018 3-55-53 PM.jpg

any ideas?

3 Replies
pedrolyra
New Contributor III

Re: Pivot Table has incorrect Total

What is the expression you are using?

If you are using "if" in the expression, try to change your "Total Format" in expression setting from Automatic to Sum.

isingh30
Contributor III

Re: Pivot Table has incorrect Total

Please share sample application or data in excel file.

Thank you!

danielco223
New Contributor III

Re: Pivot Table has incorrect Total

No "if", could I use the AGGR function to get the full total?