topic 6 Most Recent Events in QlikView https://community.qlik.com/t5/QlikView/6-Most-Recent-Events/m-p/1302401#M405775 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a dataset with a date field called 'MatchDate'.&nbsp; I need to display the rolling average certain measures for the 6 most recent games or events ... is there a simple way to achieve this?</P><P></P><P>Many thanks for your time.</P><P></P><P>TJM</P></BODY></HTML> Fri, 19 May 2017 14:22:29 GMT 2017-05-19T14:22:29Z 6 Most Recent Events https://community.qlik.com/t5/QlikView/6-Most-Recent-Events/m-p/1302401#M405775 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a dataset with a date field called 'MatchDate'.&nbsp; I need to display the rolling average certain measures for the 6 most recent games or events ... is there a simple way to achieve this?</P><P></P><P>Many thanks for your time.</P><P></P><P>TJM</P></BODY></HTML> Fri, 19 May 2017 14:22:29 GMT https://community.qlik.com/t5/QlikView/6-Most-Recent-Events/m-p/1302401#M405775 2017-05-19T14:22:29Z Re: 6 Most Recent Events https://community.qlik.com/t5/QlikView/6-Most-Recent-Events/m-p/1302402#M405776 <HTML><HEAD></HEAD><BODY><P>May be a combination of set analysis and RangeAverage or set analysis and <A href="https://community.qlik.com/qlik-blogpost/4531">The As-Of Table</A>.... May be it will be better if you can share a sample</P></BODY></HTML> Fri, 19 May 2017 14:24:43 GMT https://community.qlik.com/t5/QlikView/6-Most-Recent-Events/m-p/1302402#M405776 sunny_talwar 2017-05-19T14:24:43Z