topic Re: Re: Last 5 rows of data in QlikView https://community.qlik.com/t5/QlikView/Re-Re-Last-5-rows-of-data/m-p/656269#M676345 <HTML><HEAD></HEAD><BODY><P>Thanks treseco, that did it <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" />. </P><P></P><P>Is there any way to replicate that logic using rangeav if i was to find an average for the past 5 rows like in the excel example attached. </P><P></P><P>Regards</P><P></P><P>Rahul </P></BODY></HTML> Tue, 10 Jun 2014 13:01:02 GMT 2014-06-10T13:01:02Z Re: Re: Last 5 rows of data https://community.qlik.com/t5/QlikView/Re-Re-Last-5-rows-of-data/m-p/656269#M676345 <HTML><HEAD></HEAD><BODY><P>Thanks treseco, that did it <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" />. </P><P></P><P>Is there any way to replicate that logic using rangeav if i was to find an average for the past 5 rows like in the excel example attached. </P><P></P><P>Regards</P><P></P><P>Rahul </P></BODY></HTML> Tue, 10 Jun 2014 13:01:02 GMT https://community.qlik.com/t5/QlikView/Re-Re-Last-5-rows-of-data/m-p/656269#M676345 2014-06-10T13:01:02Z