topic Re: Trend based on Moving average in QlikView

Trend based on Moving average

Thu, 15 Jan 2015 19:19:28 GMT

Dear colleagues.

I want to create a trend line based on moving average. I created the following moving average formula which is woking fine, except for the periods after the last one which has a value, since it is considering, in this example, Sept, Oct, Nov and Dec as '0'.

Here's the formula I'm using:

=IF(vTipoInfo = 'Mensal',RANGESUM(TOP(sum(IF(ANO_EVO=ANO and MES_EVO <= MES,num(META_INDICADOR_EVO,'.###,'))), 1, ROWNO())) / ROWNO())

But the behavior I need is what I tried to show through the dotted line.

I look forward to reading your replies!

Regards,

Marcelo

Re: Trend based on Moving average

prabhuappu — Sat, 17 Jan 2015 02:05:58 GMT

Hi Marcelo,

Is the data available for Oct, Nov and Dec months or you are trying to find forecast values.

Please upload some sample application if possible.

Regards,

Prabhu Appu

Re: Trend based on Moving average

Mon, 19 Jan 2015 17:45:19 GMT

Hi Prabhu.

Thank you for the reply!

I'm trying to find forecast values. About uploading some same application, I'm not able to.

I look forward to hearing from you again.

Regards,

Marcelo

Re: Trend based on Moving average

Tue, 03 Mar 2015 20:40:00 GMT

Hi Prabhu.

Did you read my reply? I posted it in January.

Regards,

Marcelo