Qlik Community

Ask a Question

QlikView Connectivity

Discussion board for collaboration related to QlikView Connectors.

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

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
MayilVahanan

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