Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

sub total

Hello

In my exemple, the sub total (4 001.88) are wrong in the column BUDGET DEPENSE N, why ?

ROW01.png

ROW03.pngROW02.png

1 Solution

Accepted Solutions

Re: sub total

Looks correct to me. The maximum value in that column is 4001,88. If you want a sum of the maximum values as total then you need to use something like sum(aggr(Max(Budget_Depense_N), Dim1, Dim2,...,DimN)). Replace Dim1, Dim2,...,DimN with the field names of the dimensions of your chart.


talk is cheap, supply exceeds demand
2 Replies

Re: sub total

Looks correct to me. The maximum value in that column is 4001,88. If you want a sum of the maximum values as total then you need to use something like sum(aggr(Max(Budget_Depense_N), Dim1, Dim2,...,DimN)). Replace Dim1, Dim2,...,DimN with the field names of the dimensions of your chart.


talk is cheap, supply exceeds demand
Highlighted
Not applicable

Re: sub total

Thanks and happy Christmas.

Community Browser