Finding the Moving Average of a Data Series

[kebinheds]

Hi Again!

I am looking to calculate the moving average of a data series (e.g. MA 7 days). Is it possible to do this by going to the Data Manager tab > Calculated Field > Creating an Expression for the moving average?

Or do I need to write a script? I assume that's under Data Manager > Data Load Editor.

Thanks in advance for any advice!

[chrismarlow]

Hi,

I think you would normal do this in a chart using rangeavg/above, see;

RangeAvg - script and chart function ‒ QlikView

Cheers,

Chris.

[Shepherd69]

---

@chrismarlow wrote: IndigoCard Login

Hi,

I think you would normal do this in a chart using rangeavg/above, see;

RangeAvg - script and chart function ‒ QlikView

Cheers,

Chris.

---

Thanks a lot for the reply. I will try the suggested solution from your link.

[hic]

This is also a good source of information:

https://community.qlik.com/t5/QlikView-Documents/Calculating-rolling-n-period-totals-averages-or-oth...