Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ajayrai
Partner - Contributor III
Partner - Contributor III

Need help on computing rolling average calculation on Front end

Hello Everyone,

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.

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.

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.

Sample data is attached.

Regards,

Ajay Rai

0 Replies