Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Gysbert_Wassenaar

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

View solution in original post

2 Replies
Gysbert_Wassenaar

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
Not applicable
Author

Thanks and happy Christmas.