1 Reply Latest reply: Aug 15, 2017 2:09 PM by Sunny Talwar RSS

    Add Polynomial Trendlinen order 2 in Qliksense chart

    Saima SM

      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])*