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.
Any help is greatly appreciated.
Thanks