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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
fashid
Specialist
Specialist

Help with rangeavg function not working

Hi,

     I am in the process of creating 3 months rolling average and i am trying to use rangeavg function to get the rolling average

im attaching a qvw file and also the excel file for the data source.

When i apply the rangeavg function it does not work and returns me the same values. what could be the problem

5 Replies
fashid
Specialist
Specialist
Author

Please Can anybody help with this

tresesco
MVP
MVP

Your qvw file has nothing in the front-end.

fashid
Specialist
Specialist
Author

Oops sorry and i was wondering that maybe i was banned or something like that from the community ... well i figured it out on myself but really thank you for pointing it out or else i would have kept wondering all the time

nizamsha
Specialist II
Specialist II

=sum({$<[Month Year]={">=$(=Addmonths(Max([Month Year]),-3))<=$(=Max([Month Year]))"}>}Value)/4

arjunkrishnan
Partner - Creator II
Partner - Creator II

Hai Nadeem

Use This Express It Make Vry Useful For U..

=avg({$<[Month Year]={">=$(=Addmonths(Max([Month Year]),-2))<=$(=Max([Month Year]))"}>}Value)/4