Hello,
i am new to qlikview and i have a problem in forecasting the revenue using the linest_m and linest_b function.
i have used in dimention month which is the format of YYYYMM and in expression i have used 2 expression. 1st the actual revenue and 2nd to forecast the revnue. They are as follow:
1. =sum([Charge amount])
2. =linest_m(total aggr(if(sum([Charge amount]),sum([Charge amount])),Month),Month)*Month
+linest_b(total aggr(if(sum([Charge amount]),sum([Charge amount])),Month),Month)
i have uesd a bar chart. In the bar chat the actual value is shown but i am not able to get the predicted value using the 2nd expression.
If someone can please help me with this.