forcasting using Linest_m and linest_b problem

mansishah_13ms — Mon, 06 Feb 2017 05:25:19 GMT

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.

topic forcasting using Linest_m and linest_b problem in QlikView

forcasting using Linest_m and linest_b problem