topic Re: Moving Average Last 30 Days in QlikView

Moving Average Last 30 Days

vinicius_siquei — Sun, 19 Jan 2014 16:19:30 GMT

Folks,

I have one chart just like the one on the image below. What I need to do is:

- Present only the last 5 days (It must change according to the period filtered)

- Display on the line, the Moving Average from the last 30 days.

Could anyone help me build the moving average ?

In case that displaying only the last 5 days could make things to hard, It okay to handle and have bigger periods. But I do need to have the Moving Average.

I'm attaching one sample file so we can try to do that.

Thanks in advance.

Re: Moving Average Last 30 Days

Gysbert_Wassenaar — Sun, 19 Jan 2014 17:30:12 GMT

A practical way to create a moving average is using an AsOf table. See this document for an explanation and examples: Calculating rolling n-period totals, averages or other aggregations

Re: Moving Average Last 30 Days

MK_QSL — Sun, 19 Jan 2014 17:40:03 GMT

Check Enclosed file...