Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
rajeshqvd
Creator II
Creator II

Linear Line in Combo chart with 3mon and 12 mon(Like Trend Function in Excel)

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

marked as expected out put for 3 month period. we are looking for 12 months also.

 

rajeshqvd_1-1628772828724.png

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.

0 Replies