topic Using Total Of Columns in QlikView https://community.qlik.com/t5/QlikView/Using-Total-Of-Columns/m-p/154916#M31362 <HTML><HEAD></HEAD><BODY><P>Are you trying to use these outside of the chart? Column A should be pretty easy, just take whatever aggregate function you are using and add the TOTAL modifier. If it's Sum(Sales), then Sum(TOTAL Sales) will get you the expression total.</P><P>Column B is probably more complicated, because I'm assuming it uses an aggregate function other than sum, which is why you need to change the total mode. If this is the case, then the Aggr() function is needed. The Aggr() function can be a little tricky, but it should do the job. You need your original expression and also all of the dimensions in the chart. If your original expression is Count(Customers), then you would need:</P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">Aggr(Count(Customers), Dim1, Dim2.....)</PRE></BLOCKQUOTE><BR /><BR /> <P>Add as many dimension fields as you have in your chart. You may need to play around with it a bit depending on your data, but Aggr() should do the trick.</P></BODY></HTML> Fri, 22 Oct 2010 14:31:53 GMT 2010-10-22T14:31:53Z Using Total Of Columns https://community.qlik.com/t5/QlikView/Using-Total-Of-Columns/m-p/154915#M31361 <HTML><HEAD></HEAD><BODY><P>Hi guys</P><P>I have two columns A &amp; B.</P><P>Column A has a total which is calculated by setting the total mode to - Expression Total</P><P>Column B has a total which is calculated by setting the total mode to - sum(textcount) of rows.</P><P>How could I use the total for column B and divide it by the total in Column A?</P><P>Thank you</P></BODY></HTML> Fri, 22 Oct 2010 14:08:47 GMT https://community.qlik.com/t5/QlikView/Using-Total-Of-Columns/m-p/154915#M31361 2010-10-22T14:08:47Z Using Total Of Columns https://community.qlik.com/t5/QlikView/Using-Total-Of-Columns/m-p/154916#M31362 <HTML><HEAD></HEAD><BODY><P>Are you trying to use these outside of the chart? Column A should be pretty easy, just take whatever aggregate function you are using and add the TOTAL modifier. If it's Sum(Sales), then Sum(TOTAL Sales) will get you the expression total.</P><P>Column B is probably more complicated, because I'm assuming it uses an aggregate function other than sum, which is why you need to change the total mode. If this is the case, then the Aggr() function is needed. The Aggr() function can be a little tricky, but it should do the job. You need your original expression and also all of the dimensions in the chart. If your original expression is Count(Customers), then you would need:</P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">Aggr(Count(Customers), Dim1, Dim2.....)</PRE></BLOCKQUOTE><BR /><BR /> <P>Add as many dimension fields as you have in your chart. You may need to play around with it a bit depending on your data, but Aggr() should do the trick.</P></BODY></HTML> Fri, 22 Oct 2010 14:31:53 GMT https://community.qlik.com/t5/QlikView/Using-Total-Of-Columns/m-p/154916#M31362 2010-10-22T14:31:53Z