Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Pragna
New Contributor III

Unable to get the trendline on Combo Chart

Hello Team,

I want to display a trend line in my QlikSense app but for some reason when I try to use the code below it doesn't work.

Here is the code used:

=LINEST_M(total aggr(if((sum(CSR_DeliveredQuantity_LB)/sum(CSR_RequestedQuantity_LB)),(sum(CSR_DeliveredQuantity_LB)/sum(CSR_RequestedQuantity_LB))),Fiscal_Year.Period.Week),Fiscal_Year.Period.Week)*


only({1}Fiscal_Year.Period.Week)+linest_b(total aggr(if((sum(CSR_DeliveredQuantity_LB)/sum(CSR_RequestedQuantity_LB)),(sum(CSR_DeliveredQuantity_LB)/sum(CSR_RequestedQuantity_LB))),Fiscal_Year.Period.Week),Fiscal_Year.Period.Week)

The measure is Case Fill Rate(Calculated )= sum(CSR_DeliveredQuantity_LB)/sum(CSR_RequestedQuantity_LB)

The Dimension is Fiscal_Year.Period.Week ( Yr2019.Per04.Wk04)

Although, no error's are being displayed on the expression i couldn't see a trendline.Trendline.png

 

 

 

 

 

 

Any help is greatly appreciated.

Thanks