topic Re: Calculate AVG in QlikView https://community.qlik.com/t5/QlikView/Calculate-AVG/m-p/542476#M481783 <HTML><HEAD></HEAD><BODY><P>Notice! </P><P></P><P>When i select MonthYear on sep-2013 i get the right average</P><P></P><P>But when selecting Aug-2013 i get the wrong average</P></BODY></HTML> Thu, 19 Sep 2013 14:45:23 GMT 2013-09-19T14:45:23Z Calculate AVG https://community.qlik.com/t5/QlikView/Calculate-AVG/m-p/542475#M481782 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I am trying to calculate average, but the value is too low.</P><P></P><P>I have a Total of 710 with 16 unique dates.</P><P></P><P>When i do AVG(TotalAmount) it gives me 22. but it should be 44.</P><P></P><P>Ive tried to read this blog <A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/07/29/averages">http://community.qlik.com/blogs/qlikviewdesignblog/2013/07/29/averages</A></P><P></P><P>but when i do =Avg( Aggr( Sum(TotalAmount), MonthYear ) ) it gives me the sum on 710.</P></BODY></HTML> Thu, 19 Sep 2013 14:43:03 GMT https://community.qlik.com/t5/QlikView/Calculate-AVG/m-p/542475#M481782 2013-09-19T14:43:03Z Re: Calculate AVG https://community.qlik.com/t5/QlikView/Calculate-AVG/m-p/542476#M481783 <HTML><HEAD></HEAD><BODY><P>Notice! </P><P></P><P>When i select MonthYear on sep-2013 i get the right average</P><P></P><P>But when selecting Aug-2013 i get the wrong average</P></BODY></HTML> Thu, 19 Sep 2013 14:45:23 GMT https://community.qlik.com/t5/QlikView/Calculate-AVG/m-p/542476#M481783 2013-09-19T14:45:23Z Re: Calculate AVG https://community.qlik.com/t5/QlikView/Calculate-AVG/m-p/542477#M481784 <HTML><HEAD></HEAD><BODY><P>Nevermind! Im stupid!! </P><P></P><P>OF cause its due to my MonthYear takes all dates... DOH</P></BODY></HTML> Thu, 19 Sep 2013 14:58:28 GMT https://community.qlik.com/t5/QlikView/Calculate-AVG/m-p/542477#M481784 2013-09-19T14:58:28Z