Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
ajayrai
Partner - Contributor III
Partner - Contributor III
‎2018-01-26 04:21 PM

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

Preview file
72 KB
530 Views
0 Likes
0 Replies