Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have chart with dimension "Monthyear" and measure with the expression for running total over the period as below
rangeSum(Above(($(VRMonthlySaving)),0,RowNo()))
I want to add polynomial trend line order 2.
I used below formula below 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])*
Check the following post for an example:
Calculating trend lines, values and formulas on charts and tables in Qlik Sense
The 2nd Order Polynomial line is not exactly easy to implement but it is possible...