Qlik Community

Ask a Question

QlikView Connectivity

Discussion board for collaboration related to QlikView Connectors.

Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
Showing results for 
Search instead for 
Did you mean: 

Finding the Moving Average of a Data Series

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!

Labels (1)
1 Reply

Hi @TrishaSeliya 

Write in the expression tab like below

sum({<DATE = {">=$(=Date(Max(DATE)-6,'YourDateFormat'))<=$(=Date(Max(DATE),'YourDateFormat')"}>} Sales) / 7

Change the Date field based on ur date 

Thanks & Regards,
Mayil Vahanan R