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!!!
