forecasting: three years avarage

Wed, 26 Jun 2013 08:20:37 GMT

HI,

I have a requirement where I need to show forecast for the next three years from the last actual data point. For example I have data till 2012. I need to show data for 2013 as average of (2010+2011+2012)/3, then 2014 as (2011+2012+2013)/3 where 2013 was a forecasted value. Similarly for 2015 as (2012+2013+2014)/3

I have data till 2012 only. Can someone please tell me how to generate the forcasted data in chart for this. If I have to do this in load script, I dont have any issue with that either

Thanks in advance for the help

Arif

Re: forecasting: three years avarage

Wed, 26 Jun 2013 11:32:44 GMT

HI ,

If you consider Sales as field which contains the data for each year then

please try the below code in the Script and play around to make it more feasible one .

Tab:

Load

Year , Sales , ( Peek('Sales' , -1) , Peek('Sales' , -2 ) , Peek('Sales',-3) ) / 3 as Average

Resident Fact_TableName ;

Regards

Yusuf Ali

topic Re: forecasting: three years avarage in QlikView

forecasting: three years avarage

Re: forecasting: three years avarage