topic average for sum accumulation in QV 7 in QlikView https://community.qlik.com/t5/QlikView/average-for-sum-accumulation-in-QV-7/m-p/158380#M33477 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>i have an expression say for e.g. sum(Sales) and it is set to full accumulation.</P><P>how do i create a ref line on this chart to show the average on this accumulated sales figure?</P><P>i can do it using aggr function but this function doesn't exist in version 7 which my client is using now. is it other way?</P><P>thanks!</P></BODY></HTML> Sun, 16 Aug 2009 23:38:15 GMT 2009-08-16T23:38:15Z average for sum accumulation in QV 7 https://community.qlik.com/t5/QlikView/average-for-sum-accumulation-in-QV-7/m-p/158380#M33477 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>i have an expression say for e.g. sum(Sales) and it is set to full accumulation.</P><P>how do i create a ref line on this chart to show the average on this accumulated sales figure?</P><P>i can do it using aggr function but this function doesn't exist in version 7 which my client is using now. is it other way?</P><P>thanks!</P></BODY></HTML> Sun, 16 Aug 2009 23:38:15 GMT https://community.qlik.com/t5/QlikView/average-for-sum-accumulation-in-QV-7/m-p/158380#M33477 2009-08-16T23:38:15Z average for sum accumulation in QV 7 https://community.qlik.com/t5/QlikView/average-for-sum-accumulation-in-QV-7/m-p/158381#M33478 <HTML><HEAD></HEAD><BODY><P>The aggr() function has been available since 7.5.</P><P>Phil</P></BODY></HTML> Tue, 18 Aug 2009 08:39:42 GMT https://community.qlik.com/t5/QlikView/average-for-sum-accumulation-in-QV-7/m-p/158381#M33478 2009-08-18T08:39:42Z