topic Re: How to get Percentage Total? in QlikView https://community.qlik.com/t5/QlikView/How-to-get-Percentage-Total/m-p/907791#M990182 <HTML><HEAD></HEAD><BODY><P>Try this if you need to see a Avg % as total:</P><P></P><P><STRONG>Avg(Aggr(yourExpression, yourDimension))</STRONG></P><P></P><P>Replace Avg with Sum if you want to see the Sum up top.</P><P></P><P>Please note that Aggr won't work, if you are using expression label or Column function. You will need to use the actual expression which calculates that percentage.</P><P></P><P>HTH</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Tue, 21 Jul 2015 10:30:04 GMT sunny_talwar 2015-07-21T10:30:04Z How to get Percentage Total? https://community.qlik.com/t5/QlikView/How-to-get-Percentage-Total/m-p/907790#M990181 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I've a table, and I'm using Subtotals on Top of the table but I'm not getting the totals for Percentage field (%)&nbsp; column. </P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/93466_Capture.PNG" style="height: 568px; width: 620px;" /></P></BODY></HTML> Tue, 21 Jul 2015 10:26:13 GMT https://community.qlik.com/t5/QlikView/How-to-get-Percentage-Total/m-p/907790#M990181 MuraliPrasath 2015-07-21T10:26:13Z Re: How to get Percentage Total? https://community.qlik.com/t5/QlikView/How-to-get-Percentage-Total/m-p/907791#M990182 <HTML><HEAD></HEAD><BODY><P>Try this if you need to see a Avg % as total:</P><P></P><P><STRONG>Avg(Aggr(yourExpression, yourDimension))</STRONG></P><P></P><P>Replace Avg with Sum if you want to see the Sum up top.</P><P></P><P>Please note that Aggr won't work, if you are using expression label or Column function. You will need to use the actual expression which calculates that percentage.</P><P></P><P>HTH</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Tue, 21 Jul 2015 10:30:04 GMT https://community.qlik.com/t5/QlikView/How-to-get-Percentage-Total/m-p/907791#M990182 sunny_talwar 2015-07-21T10:30:04Z Re: How to get Percentage Total? https://community.qlik.com/t5/QlikView/How-to-get-Percentage-Total/m-p/907792#M990183 <HTML><HEAD></HEAD><BODY><P>thank you sooooo much. </P></BODY></HTML> Tue, 21 Jul 2015 10:38:31 GMT https://community.qlik.com/t5/QlikView/How-to-get-Percentage-Total/m-p/907792#M990183 MuraliPrasath 2015-07-21T10:38:31Z