topic Re: sub total in QlikView https://community.qlik.com/t5/QlikView/sub-total/m-p/976911#M466994 <HTML><HEAD></HEAD><BODY><P>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 <SPAN style="font-size: 13.3333px;"> Dim1, Dim2,...,DimN with the field names of the dimensions of your chart.</SPAN></P></BODY></HTML> Wed, 23 Dec 2015 17:48:45 GMT Gysbert_Wassenaar 2015-12-23T17:48:45Z sub total https://community.qlik.com/t5/QlikView/sub-total/m-p/976910#M466993 <HTML><HEAD></HEAD><BODY><P>Hello</P><P>In my exemple, the sub total (4 001.88) are wrong in the column BUDGET DEPENSE N, why ?</P><P></P><P><IMG alt="ROW01.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/109779_ROW01.png" style="width: 620px; height: 421px;" /></P><P></P><P><IMG alt="ROW03.png" class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/109790_ROW03.png" style="height: auto;" /><IMG alt="ROW02.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/109780_ROW02.png" style="width: 620px; height: 421px;" /></P></BODY></HTML> Wed, 23 Dec 2015 06:25:43 GMT https://community.qlik.com/t5/QlikView/sub-total/m-p/976910#M466993 2015-12-23T06:25:43Z Re: sub total https://community.qlik.com/t5/QlikView/sub-total/m-p/976911#M466994 <HTML><HEAD></HEAD><BODY><P>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 <SPAN style="font-size: 13.3333px;"> Dim1, Dim2,...,DimN with the field names of the dimensions of your chart.</SPAN></P></BODY></HTML> Wed, 23 Dec 2015 17:48:45 GMT https://community.qlik.com/t5/QlikView/sub-total/m-p/976911#M466994 Gysbert_Wassenaar 2015-12-23T17:48:45Z Re: sub total https://community.qlik.com/t5/QlikView/sub-total/m-p/976912#M466995 <HTML><HEAD></HEAD><BODY><P>Thanks and happy Christmas.</P></BODY></HTML> Thu, 24 Dec 2015 05:32:43 GMT https://community.qlik.com/t5/QlikView/sub-total/m-p/976912#M466995 2015-12-24T05:32:43Z