topic Re: Total sum for several dimensions in QlikView https://community.qlik.com/t5/QlikView/Total-sum-for-several-dimensions/m-p/455573#M484327 <HTML><HEAD></HEAD><BODY><P>Try sum(<STRONG>total &lt;Code&gt;</STRONG> Qty)</P></BODY></HTML> Mon, 10 Jun 2013 08:54:58 GMT Gysbert_Wassenaar 2013-06-10T08:54:58Z Total sum for several dimensions https://community.qlik.com/t5/QlikView/Total-sum-for-several-dimensions/m-p/455570#M484324 <HTML><HEAD></HEAD><BODY><P>I'm using straight table and I have a problem with calculation "Total Qty" - the formula should be sum(Qty) grouped by Code.</P><P></P><P>Can anyone help me with set analysis formula?</P><P></P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="160" style="width: 328px; border: 1px solid #000000; height: 123px;" width="326"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><P><STRONG style="color: #ffffff; font-size: 10pt; text-align: left;">Code</STRONG></P></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Sub code</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Qty</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Total Qty</STRONG></SPAN></TH></TR><TR><TD>111</TD><TD>a</TD><TD>25</TD><TD>58</TD></TR><TR><TD>111</TD><TD>b</TD><TD>23</TD><TD>58</TD></TR><TR><TD>111</TD><TD>c</TD><TD>10</TD><TD>58</TD></TR><TR><TD>222</TD><TD>a</TD><TD>11</TD><TD>68</TD></TR><TR><TD>222</TD><TD>b</TD><TD>34</TD><TD>68</TD></TR><TR><TD>333</TD><TD>c</TD><TD>23</TD><TD>68</TD></TR></TBODY></TABLE></BODY></HTML> Mon, 10 Jun 2013 08:12:00 GMT https://community.qlik.com/t5/QlikView/Total-sum-for-several-dimensions/m-p/455570#M484324 2013-06-10T08:12:00Z Re: Total sum for several dimensions https://community.qlik.com/t5/QlikView/Total-sum-for-several-dimensions/m-p/455571#M484325 <HTML><HEAD></HEAD><BODY><P>See this sample may be it help you!!</P></BODY></HTML> Mon, 10 Jun 2013 08:16:46 GMT https://community.qlik.com/t5/QlikView/Total-sum-for-several-dimensions/m-p/455571#M484325 sujeetsingh 2013-06-10T08:16:46Z Re: Total sum for several dimensions https://community.qlik.com/t5/QlikView/Total-sum-for-several-dimensions/m-p/455572#M484326 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>i don't know what you expect result. i thought you need total qty in all rows.</P><P></P><P>use this for total qty for each row</P><P></P><P>Ex: Sum(TOTAL [Total Qty])</P></BODY></HTML> Mon, 10 Jun 2013 08:38:07 GMT https://community.qlik.com/t5/QlikView/Total-sum-for-several-dimensions/m-p/455572#M484326 kumarnatarajan 2013-06-10T08:38:07Z Re: Total sum for several dimensions https://community.qlik.com/t5/QlikView/Total-sum-for-several-dimensions/m-p/455573#M484327 <HTML><HEAD></HEAD><BODY><P>Try sum(<STRONG>total &lt;Code&gt;</STRONG> Qty)</P></BODY></HTML> Mon, 10 Jun 2013 08:54:58 GMT https://community.qlik.com/t5/QlikView/Total-sum-for-several-dimensions/m-p/455573#M484327 Gysbert_Wassenaar 2013-06-10T08:54:58Z Re: Total sum for several dimensions https://community.qlik.com/t5/QlikView/Total-sum-for-several-dimensions/m-p/455574#M484328 <HTML><HEAD></HEAD><BODY><P>Try this</P><P>aggr(sum(Total Qty),<SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">Code</SPAN>)</P></BODY></HTML> Mon, 10 Jun 2013 09:09:18 GMT https://community.qlik.com/t5/QlikView/Total-sum-for-several-dimensions/m-p/455574#M484328 er_mohit 2013-06-10T09:09:18Z Re: Total sum for several dimensions https://community.qlik.com/t5/QlikView/Total-sum-for-several-dimensions/m-p/455575#M484329 <HTML><HEAD></HEAD><BODY><P>try this</P><P></P><P><STRONG>Aggr(sum([Total Qty]),Code)</STRONG></P></BODY></HTML> Mon, 10 Jun 2013 09:16:14 GMT https://community.qlik.com/t5/QlikView/Total-sum-for-several-dimensions/m-p/455575#M484329 2013-06-10T09:16:14Z