topic Re: Rolling Average in QlikView https://community.qlik.com/t5/QlikView/Rolling-Average/m-p/1013439#M642372 <HTML><HEAD></HEAD><BODY><P>You can also use an As-Of table. See <A href="https://community.qlik.com/qlik-blogpost/4531">The As-Of Table</A>.</P><P></P><P>HIC</P></BODY></HTML> Thu, 11 Feb 2016 14:38:38 GMT hic 2016-02-11T14:38:38Z Rolling Average https://community.qlik.com/t5/QlikView/Rolling-Average/m-p/1013434#M642367 <HTML><HEAD></HEAD><BODY><P>Morning all.</P><P></P><P>I have been tasked from my new client to do a 12 month rolling average in an existing Dashboard. The data is at a granular level and needs to stay at this level. I have tried the Accumulate 12 steps back but this didn't work as I do not measure by day I measure by site. Any help is much appreciated.</P><P></P><P>James</P></BODY></HTML> Thu, 11 Feb 2016 12:05:59 GMT https://community.qlik.com/t5/QlikView/Rolling-Average/m-p/1013434#M642367 2016-02-11T12:05:59Z Re: Rolling Average https://community.qlik.com/t5/QlikView/Rolling-Average/m-p/1013435#M642368 <HTML><HEAD></HEAD><BODY><P>Have you tried using RangeSum(Above/Below()) functions?</P></BODY></HTML> Thu, 11 Feb 2016 13:08:18 GMT https://community.qlik.com/t5/QlikView/Rolling-Average/m-p/1013435#M642368 sunny_talwar 2016-02-11T13:08:18Z Re: Rolling Average https://community.qlik.com/t5/QlikView/Rolling-Average/m-p/1013436#M642369 <HTML><HEAD></HEAD><BODY><P>tried that.</P></BODY></HTML> Thu, 11 Feb 2016 13:09:14 GMT https://community.qlik.com/t5/QlikView/Rolling-Average/m-p/1013436#M642369 2016-02-11T13:09:14Z Re: Rolling Average https://community.qlik.com/t5/QlikView/Rolling-Average/m-p/1013437#M642370 <HTML><HEAD></HEAD><BODY><P>Have a look here: <A href="https://community.qlik.com/docs/DOC-4252">Calculating rolling n-period totals, averages or other aggregations</A>.</P><P></P><P>- Marcus</P></BODY></HTML> Thu, 11 Feb 2016 13:13:19 GMT https://community.qlik.com/t5/QlikView/Rolling-Average/m-p/1013437#M642370 marcus_sommer 2016-02-11T13:13:19Z Re: Rolling Average https://community.qlik.com/t5/QlikView/Rolling-Average/m-p/1013438#M642371 <HTML><HEAD></HEAD><BODY><P>Hi Marcus looks interesting I will give it a try on my test data and see.</P></BODY></HTML> Thu, 11 Feb 2016 13:42:11 GMT https://community.qlik.com/t5/QlikView/Rolling-Average/m-p/1013438#M642371 2016-02-11T13:42:11Z Re: Rolling Average https://community.qlik.com/t5/QlikView/Rolling-Average/m-p/1013439#M642372 <HTML><HEAD></HEAD><BODY><P>You can also use an As-Of table. See <A href="https://community.qlik.com/qlik-blogpost/4531">The As-Of Table</A>.</P><P></P><P>HIC</P></BODY></HTML> Thu, 11 Feb 2016 14:38:38 GMT https://community.qlik.com/t5/QlikView/Rolling-Average/m-p/1013439#M642372 hic 2016-02-11T14:38:38Z