topic AVERAGE QTY in QlikView https://community.qlik.com/t5/QlikView/AVERAGE-QTY/m-p/357060#M132511 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>Use this Script ,get Avg Qty Month and Year wise </P><P></P><P>mydata:</P><P></P><P>load</P><P></P><P>monthname (posting) as Month_Year, </P><P></P><P>Avg(gia) as QTY</P><P></P><P>resudent Table group by monthname (posting);</P><P></P><P>Regards</P><P>Perumal A</P></BODY></HTML> Sun, 18 Mar 2012 05:59:35 GMT perumal_41 2012-03-18T05:59:35Z AVERAGE QTY https://community.qlik.com/t5/QlikView/AVERAGE-QTY/m-p/357059#M132510 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I need to solve this:</P><P></P><P>In this table there are many&nbsp; many data ( 3 year of data):</P><P></P><P></P><P></P><P>mydata:</P><P></P><P>load</P><P></P><P>posting , month(posting), year(posting) , week(posting),</P><P></P><P>gia as QTY</P><P></P><P>resudent ...</P><P></P><P></P><P>From this point I need to calculate the average QTY by every month by every year</P><P></P><P>This, for the server , is the problem&nbsp; If I use the AVG() </P><P></P><P>statement&nbsp; - qlikview needs many many time and memor&nbsp; to finish</P><P></P><P>the operation.. Someone coulf to help me?</P><P></P><P>Thanks.</P><P>Regards</P></BODY></HTML> Sat, 17 Mar 2012 18:10:38 GMT https://community.qlik.com/t5/QlikView/AVERAGE-QTY/m-p/357059#M132510 2012-03-17T18:10:38Z AVERAGE QTY https://community.qlik.com/t5/QlikView/AVERAGE-QTY/m-p/357060#M132511 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>Use this Script ,get Avg Qty Month and Year wise </P><P></P><P>mydata:</P><P></P><P>load</P><P></P><P>monthname (posting) as Month_Year, </P><P></P><P>Avg(gia) as QTY</P><P></P><P>resudent Table group by monthname (posting);</P><P></P><P>Regards</P><P>Perumal A</P></BODY></HTML> Sun, 18 Mar 2012 05:59:35 GMT https://community.qlik.com/t5/QlikView/AVERAGE-QTY/m-p/357060#M132511 perumal_41 2012-03-18T05:59:35Z