topic calculating rolling avg in QlikView https://community.qlik.com/t5/QlikView/calculating-rolling-avg/m-p/229437#M81364 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>We have sales revenue for each month and the user like to have a comparison with rolling average of previous 3 months with the actuals. Can anybody suggest how to do this.</P><P>Actuals Rolling Avg</P><P>5000 5000</P><P>6000 5500 ((5000+6000)/2)</P><P>4000 5000 ((5000+6000+4000)/3)</P><P>8000 6000 (6000+4000+8000)/3)</P><P>Thanks and Regards,</P><P>Raghav</P><P></P><P>Regards,</P><P>Raghav</P></BODY></HTML> Tue, 21 Dec 2010 14:01:53 GMT raghavsurya 2010-12-21T14:01:53Z calculating rolling avg https://community.qlik.com/t5/QlikView/calculating-rolling-avg/m-p/229437#M81364 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>We have sales revenue for each month and the user like to have a comparison with rolling average of previous 3 months with the actuals. Can anybody suggest how to do this.</P><P>Actuals Rolling Avg</P><P>5000 5000</P><P>6000 5500 ((5000+6000)/2)</P><P>4000 5000 ((5000+6000+4000)/3)</P><P>8000 6000 (6000+4000+8000)/3)</P><P>Thanks and Regards,</P><P>Raghav</P><P></P><P>Regards,</P><P>Raghav</P></BODY></HTML> Tue, 21 Dec 2010 14:01:53 GMT https://community.qlik.com/t5/QlikView/calculating-rolling-avg/m-p/229437#M81364 raghavsurya 2010-12-21T14:01:53Z calculating rolling avg https://community.qlik.com/t5/QlikView/calculating-rolling-avg/m-p/229438#M81365 <HTML><HEAD></HEAD><BODY><P>Hi Raghav,</P><P>see QV help for <STRONG>rangeavg (above(Sum(x), 0, 3)</STRONG> as example.</P><P>Good luck!</P><P>Rainer</P></BODY></HTML> Tue, 21 Dec 2010 14:10:06 GMT https://community.qlik.com/t5/QlikView/calculating-rolling-avg/m-p/229438#M81365 2010-12-21T14:10:06Z calculating rolling avg https://community.qlik.com/t5/QlikView/calculating-rolling-avg/m-p/229439#M81366 <HTML><HEAD></HEAD><BODY><P>Thanks Rainer</P></BODY></HTML> Tue, 21 Dec 2010 14:20:23 GMT https://community.qlik.com/t5/QlikView/calculating-rolling-avg/m-p/229439#M81366 raghavsurya 2010-12-21T14:20:23Z calculating rolling avg https://community.qlik.com/t5/QlikView/calculating-rolling-avg/m-p/229440#M81367 <HTML><HEAD></HEAD><BODY><P>Raghav,</P><P>here are an example.</P><P>Rainer</P></BODY></HTML> Tue, 21 Dec 2010 14:23:26 GMT https://community.qlik.com/t5/QlikView/calculating-rolling-avg/m-p/229440#M81367 2010-12-21T14:23:26Z calculating rolling avg https://community.qlik.com/t5/QlikView/calculating-rolling-avg/m-p/229441#M81368 <HTML><HEAD></HEAD><BODY><P>thanks dude <IMG alt="Smile" src="http://community.qlik.com/emoticons/emotion-1.gif" /></P></BODY></HTML> Tue, 21 Dec 2010 14:35:17 GMT https://community.qlik.com/t5/QlikView/calculating-rolling-avg/m-p/229441#M81368 raghavsurya 2010-12-21T14:35:17Z