topic Re: Average in App Development https://community.qlik.com/t5/App-Development/Average/m-p/1455051#M35772 <HTML><HEAD></HEAD><BODY><P>Sum(Quantity)/Sum(TOTAL &lt;Ano&gt; Quantity)</P></BODY></HTML> Wed, 27 Dec 2017 04:14:43 GMT Anonymous 2017-12-27T04:14:43Z Average https://community.qlik.com/t5/App-Development/Average/m-p/1455049#M35770 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P>I need to calculate the percentage in a pivoting table with 2 dimensions, Imputation and Year. I use Sum (Quantity) / Sum (Total Amount) but it does not work. I have tried several without success.</P><P></P><P>Desired result:<IMG alt="Captura.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/188176_Captura.PNG" style="height: auto;" /></P><P><IMG alt="Captura1.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/188190_Captura1.PNG" style="height: auto;" /></P></BODY></HTML> Tue, 26 Dec 2017 22:51:49 GMT https://community.qlik.com/t5/App-Development/Average/m-p/1455049#M35770 spividori 2017-12-26T22:51:49Z Re: Average https://community.qlik.com/t5/App-Development/Average/m-p/1455050#M35771 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>Sum(Quantity)/Sum(TOTAL &lt;Ano&gt; Quantity)</STRONG></P></BODY></HTML> Wed, 27 Dec 2017 00:45:15 GMT https://community.qlik.com/t5/App-Development/Average/m-p/1455050#M35771 sunny_talwar 2017-12-27T00:45:15Z Re: Average https://community.qlik.com/t5/App-Development/Average/m-p/1455051#M35772 <HTML><HEAD></HEAD><BODY><P>Sum(Quantity)/Sum(TOTAL &lt;Ano&gt; Quantity)</P></BODY></HTML> Wed, 27 Dec 2017 04:14:43 GMT https://community.qlik.com/t5/App-Development/Average/m-p/1455051#M35772 Anonymous 2017-12-27T04:14:43Z Re: Average https://community.qlik.com/t5/App-Development/Average/m-p/1455052#M35773 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P>Thanks for answering. It works perfect.</P><P></P><P>Regards.</P></BODY></HTML> Wed, 27 Dec 2017 10:23:17 GMT https://community.qlik.com/t5/App-Development/Average/m-p/1455052#M35773 spividori 2017-12-27T10:23:17Z