topic Chart Properties : Total Mode in QlikView

Chart Properties : Total Mode

Black_Hole — Sat, 16 Nov 2024 01:49:26 GMT

Hello all,

I have an expression in my table box.

I checked the following box in order to display the total sum on the head of the column with expression.

But, the value calculated is not correct.

Please could you confirm that I checked the correct box.

The purpose is to have the total sum of the column with expression.

Thank you in advance for your help.

Re: Chart Properties : Total Mode

gavinlaird — Fri, 29 Nov 2019 23:48:59 GMT

Could you please paste your expression?

Checking "Expression Total" under Total Mode, rather than "Sum of Rows" will calculate the total once across all dimensions. With "Sum of Rows" mode, the chart will calculate a separate "AmountCalculated" value for each combination of dimensions, then sum up those values.