forcasting using Linest_m and linest_b problem

[mansishah_13ms]

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.