Hi
I have chart with dimension "Monthyear" and measure with the expression for running total over the period as below
angeSum(Above(($(VRMonthlySaving)),0,RowNo()))
I want to add polynomial trend line order 2.
I used below formula but its not for polynomial. I m using QlikSenes 3 version. Please help. thanks
linest_m(total aggr(if(($(VRMonthlySaving)),($(VRMonthlySaving))),
[VRDate.autoCalendar.YearMonth]),[VRDate.autoCalendar.YearMonth])*
only({1}[VRDate.autoCalendar.YearMonth])+
(linest_b(total aggr(if(($(VRMonthlySaving)),($(VRMonthlySaving))),
[VRDate.autoCalendar.YearMonth]),[VRDate.autoCalendar.YearMonth])