topic Re: Help with rangeavg function not working in QlikView

Help with rangeavg function not working

fashid — Wed, 02 Apr 2014 07:10:42 GMT

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

Re: Help with rangeavg function not working

fashid — Thu, 03 Apr 2014 08:35:12 GMT

Please Can anybody help with this

Re: Help with rangeavg function not working

tresB — Thu, 03 Apr 2014 08:37:38 GMT

Your qvw file has nothing in the front-end.

Re: Help with rangeavg function not working

fashid — Fri, 04 Apr 2014 05:53:15 GMT

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

Re: Help with rangeavg function not working

nizamsha — Fri, 04 Apr 2014 06:45:44 GMT

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

Re: Help with rangeavg function not working

arjunkrishnan — Fri, 04 Apr 2014 07:34:24 GMT

Hai Nadeem

Use This Express It Make Vry Useful For U..

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