Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

dhulipudi
New 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
sureshqv
Esteemed Contributor 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

dhulipudi
New 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

dhulipudi
New 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

Re: 7 day rolling avg

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

Community Browser