topic Re: avg calculation? in QlikView https://community.qlik.com/t5/QlikView/avg-calculation/m-p/706599#M1052393 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try using Aggr() like below</P><P></P><P>=Sum(Aggr(Expression, Country))</P><P></P><P>Note: Replace Expression with your Average expression.</P><P></P><P>If not working attach some sample file.</P><P></P><P>Regards,</P><P>jagan.</P></BODY></HTML> Tue, 28 Oct 2014 03:44:26 GMT jagan 2014-10-28T03:44:26Z avg calculation? https://community.qlik.com/t5/QlikView/avg-calculation/m-p/706597#M1052391 <HTML><HEAD></HEAD><BODY><P>Hi pls tell me </P><P></P><P></P><P><IMG alt="Capture.PNG.png" class="jive-image" height="300" src="https://community.qlik.com/legacyfs/online/69800_Capture.PNG.png" style="width: 958.208955223881px; height: 300px;" width="958" /></P></BODY></HTML> Mon, 27 Oct 2014 19:52:23 GMT https://community.qlik.com/t5/QlikView/avg-calculation/m-p/706597#M1052391 2014-10-27T19:52:23Z Re: avg calculation? https://community.qlik.com/t5/QlikView/avg-calculation/m-p/706598#M1052392 <HTML><HEAD></HEAD><BODY><P>hmmm maybe with aggr() .&nbsp; Can you post a QVW and we can test and apply a solution ?</P></BODY></HTML> Mon, 27 Oct 2014 20:28:45 GMT https://community.qlik.com/t5/QlikView/avg-calculation/m-p/706598#M1052392 JonnyPoole 2014-10-27T20:28:45Z Re: avg calculation? https://community.qlik.com/t5/QlikView/avg-calculation/m-p/706599#M1052393 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try using Aggr() like below</P><P></P><P>=Sum(Aggr(Expression, Country))</P><P></P><P>Note: Replace Expression with your Average expression.</P><P></P><P>If not working attach some sample file.</P><P></P><P>Regards,</P><P>jagan.</P></BODY></HTML> Tue, 28 Oct 2014 03:44:26 GMT https://community.qlik.com/t5/QlikView/avg-calculation/m-p/706599#M1052393 jagan 2014-10-28T03:44:26Z Re: avg calculation? https://community.qlik.com/t5/QlikView/avg-calculation/m-p/706600#M1052394 <HTML><HEAD></HEAD><BODY><P>select <STRONG>sum of rows</STRONG> for average expression&nbsp; inplace of expression total</P></BODY></HTML> Tue, 28 Oct 2014 05:25:19 GMT https://community.qlik.com/t5/QlikView/avg-calculation/m-p/706600#M1052394 SunilChauhan 2014-10-28T05:25:19Z