Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
April 13–15 - Dare to Unleash a New Professional You at Qlik Connect 2026: Register 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
Partner - Champion III
Partner - Champion III

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
Partner - Champion III
Partner - Champion III

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.