Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Pragna
Contributor III
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

0 Replies