Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

7 day rolling avg

Hi All, Need Help..

I want to create a 7 day rolling average but I need to use Month year on X-axis.


I am using: rangeavg(above(sum(sales),0,7))


X Axis: Month Year


Rolling average will be based on Month year, I need to calculate it based on 7 days sales.


thumbnail_Rollin.jpg



Tags (1)
5 Replies
Highlighted
Champion III
Champion III

Re: 7 day rolling avg

Highlighted

Re: 7 day rolling avg

I would suggest you to use The As-Of Table here to remove any unnecessary complication on the front end

Highlighted
Contributor
Contributor

Re: 7 day rolling avg

Thanks Sunny for the reply.

1. The app is in Prod so I won't be able to change it.

2. Is this As of table will work for 7 day as well instead of month

Highlighted
Contributor
Contributor

Re: 7 day rolling avg

The end suggestion was use Monthasof but its not possible as of now.

rangeavg(above( sum(sales),0,7) )

This is working fine if I use x-axis as days.

but the requirement is month year and There should be 4 data points for each month

Highlighted

Re: 7 day rolling avg

I can work for 7 days, month, quarter or an year