Moving average for beginners

[juliag]

Hi everyone,

I just started with QlikSense and I would like to know how to express a moving average of data. I have found the formula rangeavg(above(sum(Output),0,3)), but it doesn´t work in my case. Here is a screenshot of my false solution.

This data should be right instead: 

Does someone know the solution for this problem?

Kind regards,

Julia

[andoryuu]

Try Sum(Aggr(RangeAvg(Above(sum(Output),0,3)),Gesmtwerte))

[juliag]

Now the data from "Prognose 2019" jumped to 0.

[juliag · Accepted solution]

Found the formula!

=aggr(rangeAvg(above(sum(Output),1,2)),ID,OutputDate)