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
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out 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: 
devender
Contributor II
Contributor II
‎2022-07-19 04:11 AM

rolling avarage

hi,

can you pls help about rolling avarage for last three months and function or formula..

Labels (1)
Labels
775 Views
0 Likes
1 Reply
MayilVahanan
MVP
MVP
‎2022-07-19 04:17 AM

Hi

Its depends on the requirement.

Try like rangeavg(above(sum(sales),0,3))
or

https://community.qlik.com/t5/QlikView-App-Dev/Rolling-12-Months-Average/m-p/1364880

 

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
772 Views
0 Likes