Forecasting

Anonymous — Thu, 20 Aug 2015 18:09:26 GMT

Hello all,

Thanks for all your help in the Qlik Community. Can you please help me solve my forecasting problem in QlikView?

Below are the details:

I am trying to do the forecasting by using the Holt's exponential smoothing. There is a "Actual value" in the attached sheet which is coming from the average of some other values and the formula for the forecast equation in the spread sheet is =[$M$1*B3+(1-$M$1)*(C2+D2)] and for the trend line it is =[$M$2*(C3-C2)+(1-$M$2)*(D2)]...where M1, B3,C2,C3,M2, D2 are the columns.The dimension I am using is Year and I am trying to forecast the value for 2016. Thanks in advance!!!

Pramod

topic Forecasting in QlikView

Forecasting