topic Re: Problem with Avg of Avg! in QlikView https://community.qlik.com/t5/QlikView/Problem-with-Avg-of-Avg/m-p/1328283#M617027 <HTML><HEAD></HEAD><BODY><P>I assume that you need something like this:</P><P></P><P>avg(aggr(SUM(Price_for_One*Quantity)/Sum(Quantity), OfficeDimension))</P><P></P><P>- Marcus</P></BODY></HTML> Thu, 11 May 2017 13:23:53 GMT marcus_sommer 2017-05-11T13:23:53Z Problem with Avg of Avg! https://community.qlik.com/t5/QlikView/Problem-with-Avg-of-Avg/m-p/1328280#M617021 <HTML><HEAD></HEAD><BODY><P>Hi, guys.</P><P>I Need your help with folowing problem.</P><P>I should to Show in KPI object (In Text Object) the avg of avg for all offices.</P><P>For the moment, I have this formula to count Avg for any office wich i choose: SUM(Price_for_One*Quantity)/Sum(Quantity).</P><P>Now I want to know, how to count Avg from this formula for all offices.</P></BODY></HTML> Thu, 11 May 2017 13:13:29 GMT https://community.qlik.com/t5/QlikView/Problem-with-Avg-of-Avg/m-p/1328280#M617021 2017-05-11T13:13:29Z Re: Problem with Avg of Avg! https://community.qlik.com/t5/QlikView/Problem-with-Avg-of-Avg/m-p/1328281#M617024 <HTML><HEAD></HEAD><BODY><P>I am sure, This is not right approach but try</P><P><STRONG>RangeAvg((<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">SUM(Price_for_One*Quantity)/Sum(Quantity</SPAN>),Avg(1))</STRONG></P><P><STRONG>Or</STRONG></P><P><STRONG><STRONG style="font-size: 13.3333px;">RangeAvg((<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">SUM(Price_for_One*Quantity)/Sum(Quantity</SPAN>),0)</STRONG></STRONG></P></BODY></HTML> Thu, 11 May 2017 13:16:12 GMT https://community.qlik.com/t5/QlikView/Problem-with-Avg-of-Avg/m-p/1328281#M617024 Anil_Babu_Samineni 2017-05-11T13:16:12Z Re: Problem with Avg of Avg! https://community.qlik.com/t5/QlikView/Problem-with-Avg-of-Avg/m-p/1328282#M617025 <HTML><HEAD></HEAD><BODY><P>Thanks for you answer, but Why you sure that it's not a good way for the task solution?</P></BODY></HTML> Thu, 11 May 2017 13:19:16 GMT https://community.qlik.com/t5/QlikView/Problem-with-Avg-of-Avg/m-p/1328282#M617025 2017-05-11T13:19:16Z Re: Problem with Avg of Avg! https://community.qlik.com/t5/QlikView/Problem-with-Avg-of-Avg/m-p/1328283#M617027 <HTML><HEAD></HEAD><BODY><P>I assume that you need something like this:</P><P></P><P>avg(aggr(SUM(Price_for_One*Quantity)/Sum(Quantity), OfficeDimension))</P><P></P><P>- Marcus</P></BODY></HTML> Thu, 11 May 2017 13:23:53 GMT https://community.qlik.com/t5/QlikView/Problem-with-Avg-of-Avg/m-p/1328283#M617027 marcus_sommer 2017-05-11T13:23:53Z Re: Problem with Avg of Avg! https://community.qlik.com/t5/QlikView/Problem-with-Avg-of-Avg/m-p/1328284#M617029 <HTML><HEAD></HEAD><BODY><P>I thougth about this method, too. Thanks a lot! ) But, what do think can I get the information which need vy this method? I mean Avg of Avg af all Offices?</P></BODY></HTML> Thu, 11 May 2017 13:26:43 GMT https://community.qlik.com/t5/QlikView/Problem-with-Avg-of-Avg/m-p/1328284#M617029 2017-05-11T13:26:43Z