topic Custom Others or Total calculation in straight table in QlikView https://community.qlik.com/t5/QlikView/Custom-Others-or-Total-calculation-in-straight-table/m-p/386833#M566878 <HTML><HEAD></HEAD><BODY><P>Is there a way to customize the Others or Total aggregation in a straight table?</P><P></P><P><SPAN style="font-size: 9.0pt; font-family: 'MS Shell Dlg 2','sans-serif'; color: black;">What I want: max(.15 - TotalSales / TotalSectorSales, 0) * TotalSectorSales where Total Sales = Sum_{c in companies} (Sales_c) and the same for sector sales<BR /></SPAN></P><P></P><P><SPAN style="font-size: 9.0pt; font-family: 'MS Shell Dlg 2','sans-serif'; color: black;"> QV seems to do the aggregation this way: </SPAN></P><P></P><P><SPAN style="font-size: 9.0pt; font-family: 'MS Shell Dlg 2','sans-serif'; color: black;">Sum_{c in companies} ( max(.15 - Sales_c / SectorSales_c, 0) * SectorSales_c)</SPAN></P><P></P><P></P><P><SPAN style="font-size: 9.0pt; font-family: 'MS Shell Dlg 2','sans-serif'; color: black;">Your help is greatly appreciated.<BR /></SPAN></P></BODY></HTML> Wed, 28 Nov 2012 16:47:14 GMT 2012-11-28T16:47:14Z Custom Others or Total calculation in straight table https://community.qlik.com/t5/QlikView/Custom-Others-or-Total-calculation-in-straight-table/m-p/386833#M566878 <HTML><HEAD></HEAD><BODY><P>Is there a way to customize the Others or Total aggregation in a straight table?</P><P></P><P><SPAN style="font-size: 9.0pt; font-family: 'MS Shell Dlg 2','sans-serif'; color: black;">What I want: max(.15 - TotalSales / TotalSectorSales, 0) * TotalSectorSales where Total Sales = Sum_{c in companies} (Sales_c) and the same for sector sales<BR /></SPAN></P><P></P><P><SPAN style="font-size: 9.0pt; font-family: 'MS Shell Dlg 2','sans-serif'; color: black;"> QV seems to do the aggregation this way: </SPAN></P><P></P><P><SPAN style="font-size: 9.0pt; font-family: 'MS Shell Dlg 2','sans-serif'; color: black;">Sum_{c in companies} ( max(.15 - Sales_c / SectorSales_c, 0) * SectorSales_c)</SPAN></P><P></P><P></P><P><SPAN style="font-size: 9.0pt; font-family: 'MS Shell Dlg 2','sans-serif'; color: black;">Your help is greatly appreciated.<BR /></SPAN></P></BODY></HTML> Wed, 28 Nov 2012 16:47:14 GMT https://community.qlik.com/t5/QlikView/Custom-Others-or-Total-calculation-in-straight-table/m-p/386833#M566878 2012-11-28T16:47:14Z