topic Re: Change Total% to Average% in QlikView https://community.qlik.com/t5/QlikView/Change-Total-to-Average/m-p/854229#M1018721 <HTML><HEAD></HEAD><BODY><P>Change your % expression to avg(aggr(sum(Quantity)/sum(Total Quantity),Item))</P></BODY></HTML> Sun, 05 Apr 2015 16:28:10 GMT Gysbert_Wassenaar 2015-04-05T16:28:10Z Change Total% to Average% https://community.qlik.com/t5/QlikView/Change-Total-to-Average/m-p/854228#M1018719 <HTML><HEAD></HEAD><BODY><P>Dear all</P><P></P><P>Can someone help to change total of 100% to an average of 12.5% ?.</P><P></P><P>Thank You</P><P>Tracy</P></BODY></HTML> Sun, 05 Apr 2015 15:55:30 GMT https://community.qlik.com/t5/QlikView/Change-Total-to-Average/m-p/854228#M1018719 tracycrown 2015-04-05T15:55:30Z Re: Change Total% to Average% https://community.qlik.com/t5/QlikView/Change-Total-to-Average/m-p/854229#M1018721 <HTML><HEAD></HEAD><BODY><P>Change your % expression to avg(aggr(sum(Quantity)/sum(Total Quantity),Item))</P></BODY></HTML> Sun, 05 Apr 2015 16:28:10 GMT https://community.qlik.com/t5/QlikView/Change-Total-to-Average/m-p/854229#M1018721 Gysbert_Wassenaar 2015-04-05T16:28:10Z Re: Change Total% to Average% https://community.qlik.com/t5/QlikView/Change-Total-to-Average/m-p/854230#M1018722 <HTML><HEAD></HEAD><BODY><P>Dear Gysbert Wassenaar</P><P></P><P>Thank you so much for your quick response.</P><P></P><P>You are so clever, I have a lot to learn.</P><P></P><P>Tracy</P></BODY></HTML> Sun, 05 Apr 2015 23:50:05 GMT https://community.qlik.com/t5/QlikView/Change-Total-to-Average/m-p/854230#M1018722 tracycrown 2015-04-05T23:50:05Z