Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Black_Hole
Contributor II

Chart Properties : Total Mode

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.

ChartProperties.PNG

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.

Labels (1)
1 Reply
Highlighted
gavinlaird
New Contributor III

Re: Chart Properties : Total Mode

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.