topic Re: Help with the Aggr function in QlikView https://community.qlik.com/t5/QlikView/Help-with-the-Aggr-function/m-p/1019231#M925864 <HTML><HEAD></HEAD><BODY><P>Your second request can be achieved by using</P><P></P><P>=Num(sum(Data) / sum(TOTAL&lt;Company&gt; Data),'##.00%')</P><P></P><P></P><P>Not sure about your first table, where do you want to show that average?</P></BODY></HTML> Wed, 30 Mar 2016 16:20:08 GMT swuehl 2016-03-30T16:20:08Z Help with the Aggr function https://community.qlik.com/t5/QlikView/Help-with-the-Aggr-function/m-p/1019229#M925862 <HTML><HEAD></HEAD><BODY><P>Please take a look at the QVW attached. I believe my requests are straightforward, but I can't get them to work.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Help-with-the-Aggr-function/m-p/1019229#M925862 hobanwashburne 2020-11-25T16:16:04Z Re: Help with the Aggr function https://community.qlik.com/t5/QlikView/Help-with-the-Aggr-function/m-p/1019230#M925863 <HTML><HEAD></HEAD><BODY><P>This?</P><P></P><P><IMG __jive_id="119935" alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/119935_Capture.PNG" style="height: 202px; width: 620px;" /></P><P></P><P>1st table expression:</P><P><STRONG>Avg(Aggr(Sum(Data), Company, Channel, Customer, ProductCategory, Year))</STRONG></P><P></P><P>2nd table expression:</P><P><STRONG>sum(Data)/Sum(TOTAL &lt;Company&gt;Data)</STRONG></P></BODY></HTML> Wed, 30 Mar 2016 16:19:43 GMT https://community.qlik.com/t5/QlikView/Help-with-the-Aggr-function/m-p/1019230#M925863 sunny_talwar 2016-03-30T16:19:43Z Re: Help with the Aggr function https://community.qlik.com/t5/QlikView/Help-with-the-Aggr-function/m-p/1019231#M925864 <HTML><HEAD></HEAD><BODY><P>Your second request can be achieved by using</P><P></P><P>=Num(sum(Data) / sum(TOTAL&lt;Company&gt; Data),'##.00%')</P><P></P><P></P><P>Not sure about your first table, where do you want to show that average?</P></BODY></HTML> Wed, 30 Mar 2016 16:20:08 GMT https://community.qlik.com/t5/QlikView/Help-with-the-Aggr-function/m-p/1019231#M925864 swuehl 2016-03-30T16:20:08Z