rolling avarage

[devender]

hi,

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

[MayilVahanan]

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