Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
raghavsurya
Partner
Partner

calculating rolling avg

Hi All,

We have sales revenue for each month and the user like to have a comparison with rolling average of previous 3 months with the actuals. Can anybody suggest how to do this.

Actuals Rolling Avg

5000 5000

6000 5500 ((5000+6000)/2)

4000 5000 ((5000+6000+4000)/3)

8000 6000 (6000+4000+8000)/3)

Thanks and Regards,

Raghav

Regards,

Raghav

1 Solution

Accepted Solutions
Not applicable

Raghav,

here are an example.

Rainer

View solution in original post

4 Replies
Not applicable

Hi Raghav,

see QV help for rangeavg (above(Sum(x), 0, 3) as example.

Good luck!

Rainer

raghavsurya
Partner
Partner
Author

Thanks Rainer

Not applicable

Raghav,

here are an example.

Rainer

View solution in original post

raghavsurya
Partner
Partner
Author

thanks dude Smile