Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
frederikverhaeghe
Contributor II
Contributor II

moving average

Hello,

I have a set of monthly measurement values dating back from 2014 to now. 

I would like to have a plot with, next to the monthly values, a moving average over a year. 

I use the following formula:

rangeavg(above(avg(value),0,12))

This formula works fine from 2015 onwards, since at that time I have 12 data points prior so a yearly moving average makes sense. For 2014 of course, this is not the case. 

Is there a way to only start plotting from 2015 onwards, while simultaneously taking into account the 2014 data? 

If I try this via a set analysis  ( year = {">=2015"} ) the values for 2015 are wrong...

0 Replies