topic Need help on computing rolling average calculation on Front end in QlikView https://community.qlik.com/t5/QlikView/Need-help-on-computing-rolling-average-calculation-on-Front-end/m-p/7985#M1226 <HTML><HEAD></HEAD><BODY><P>Hello Everyone,</P><P></P><P>I have a case where I am calculating monthly % on front end. Once it is calculated in the same chart I need to calculate the average of last 5 months including current month. </P><P></P><P>I am using rangeavg and above to do this but it's not working for the cases untill I get 4 months above that month. Till that case it only calculates whichever month available. </P><P></P><P>For example my table contains data from Jan-2017 to Jan-2018 it starts calculating correctly after May-2017, but desired output is to calculate for Jan-2017 by considering Sep-16 to Jan -17 instead of considering only Jan-17.</P><P></P><P>Sample data is attached.</P><P></P><P></P><P></P><P></P><P>Regards,</P><P>Ajay Rai</P></BODY></HTML> Fri, 26 Jan 2018 21:21:14 GMT ajayrai 2018-01-26T21:21:14Z Need help on computing rolling average calculation on Front end https://community.qlik.com/t5/QlikView/Need-help-on-computing-rolling-average-calculation-on-Front-end/m-p/7985#M1226 <HTML><HEAD></HEAD><BODY><P>Hello Everyone,</P><P></P><P>I have a case where I am calculating monthly % on front end. Once it is calculated in the same chart I need to calculate the average of last 5 months including current month. </P><P></P><P>I am using rangeavg and above to do this but it's not working for the cases untill I get 4 months above that month. Till that case it only calculates whichever month available. </P><P></P><P>For example my table contains data from Jan-2017 to Jan-2018 it starts calculating correctly after May-2017, but desired output is to calculate for Jan-2017 by considering Sep-16 to Jan -17 instead of considering only Jan-17.</P><P></P><P>Sample data is attached.</P><P></P><P></P><P></P><P></P><P>Regards,</P><P>Ajay Rai</P></BODY></HTML> Fri, 26 Jan 2018 21:21:14 GMT https://community.qlik.com/t5/QlikView/Need-help-on-computing-rolling-average-calculation-on-Front-end/m-p/7985#M1226 ajayrai 2018-01-26T21:21:14Z