Discussion board where members can get started with Qlik Sense.
Hi, I have a pivot table that is displaying the incorrect total. in a straight table, it is displaying as below:
but in a pivot, it shows up like this
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.
Please share sample application or data in excel file.
No "if", could I use the AGGR function to get the full total?