Hi All,
I am trying to get forecast line in combo chart. getting wrong values by using below Qlik sense formula and we should add 2 forecast lines 1 for 3 month period and 2nd one 12 month period like excel formula. =TREND($C$2:$C$4,$B$2:$B$4,B6) this is for 3month same like we are expecting 12 also.
input
![rajeshqvd_0-1628772785871.png rajeshqvd_0-1628772785871.png](https://community.qlik.com/t5/image/serverpage/image-id/60019i4C7F23897B3428E4/image-size/medium?v=v2&px=400)
marked as expected out put for 3 month period. we are looking for 12 months also.
![rajeshqvd_1-1628772828724.png rajeshqvd_1-1628772828724.png](https://community.qlik.com/t5/image/serverpage/image-id/60020iF006A773C1625A12/image-size/medium?v=v2&px=400)
Red color trend is calculated forecast below is formula. getting wrong values.
=LINEST_M(total aggr(IF(sum([Sales]),sum([Sales])),ID),ID)
* only(ID)
+ LINEST_B(total aggr(IF(sum([Sales]),sum([Sales])),ID),ID)
thanks in advance.