topic Re: Average Calculation in QlikView https://community.qlik.com/t5/QlikView/Average-Calculation/m-p/882375#M998662 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt; line-height: 1.5em;">I have tried this expression sum( aggr( rangeavg(below( sum(sales),0,3) ),Week)) but it is not returning correct result</SPAN></P></BODY></HTML> Tue, 23 Jun 2015 14:23:56 GMT Vinothishere 2015-06-23T14:23:56Z Average Calculation https://community.qlik.com/t5/QlikView/Average-Calculation/m-p/882373#M998658 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>&nbsp;&nbsp;&nbsp; I have daily sales forecast data till 2017, I have to calculate the average of next three weeks sales in chart expression.For every week&nbsp; I have to display the average of next 3 weeks value.</P><P>&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 10pt; line-height: 1.5em;">How to calculate?</SPAN></P><P></P><P>Thanks in advance</P><P></P><P>Regards,</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"> </SPAN><SPAN style="font-size: 10pt; line-height: 1.5em;">VR</SPAN></P></BODY></HTML> Tue, 23 Jun 2015 14:00:40 GMT https://community.qlik.com/t5/QlikView/Average-Calculation/m-p/882373#M998658 Vinothishere 2015-06-23T14:00:40Z Re: Average Calculation https://community.qlik.com/t5/QlikView/Average-Calculation/m-p/882374#M998660 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/docs/DOC-4252">Calculating rolling n-period totals, averages or other aggregations</A></P></BODY></HTML> Tue, 23 Jun 2015 14:10:05 GMT https://community.qlik.com/t5/QlikView/Average-Calculation/m-p/882374#M998660 MK_QSL 2015-06-23T14:10:05Z Re: Average Calculation https://community.qlik.com/t5/QlikView/Average-Calculation/m-p/882375#M998662 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt; line-height: 1.5em;">I have tried this expression sum( aggr( rangeavg(below( sum(sales),0,3) ),Week)) but it is not returning correct result</SPAN></P></BODY></HTML> Tue, 23 Jun 2015 14:23:56 GMT https://community.qlik.com/t5/QlikView/Average-Calculation/m-p/882375#M998662 Vinothishere 2015-06-23T14:23:56Z Re: Average Calculation https://community.qlik.com/t5/QlikView/Average-Calculation/m-p/882376#M998664 <HTML><HEAD></HEAD><BODY><P>You have to create as of table !</P><P>Read the full blog and try to implement the same !</P></BODY></HTML> Tue, 23 Jun 2015 14:27:54 GMT https://community.qlik.com/t5/QlikView/Average-Calculation/m-p/882376#M998664 MK_QSL 2015-06-23T14:27:54Z Re: Average Calculation https://community.qlik.com/t5/QlikView/Average-Calculation/m-p/882377#M998666 <HTML><HEAD></HEAD><BODY><P>Is there any way to calculate it in the chart expression?</P></BODY></HTML> Tue, 23 Jun 2015 14:45:15 GMT https://community.qlik.com/t5/QlikView/Average-Calculation/m-p/882377#M998666 Vinothishere 2015-06-23T14:45:15Z Re: Average Calculation https://community.qlik.com/t5/QlikView/Average-Calculation/m-p/882378#M998668 <HTML><HEAD></HEAD><BODY><P>You can but on selecting certain field, will alter your result.</P></BODY></HTML> Tue, 23 Jun 2015 15:08:23 GMT https://community.qlik.com/t5/QlikView/Average-Calculation/m-p/882378#M998668 MK_QSL 2015-06-23T15:08:23Z Re: Average Calculation https://community.qlik.com/t5/QlikView/Average-Calculation/m-p/882379#M998669 <HTML><HEAD></HEAD><BODY><P>I have created asof table but its not returning expected result.</P></BODY></HTML> Wed, 24 Jun 2015 14:52:41 GMT https://community.qlik.com/t5/QlikView/Average-Calculation/m-p/882379#M998669 Vinothishere 2015-06-24T14:52:41Z