0 Replies Latest reply: Aug 15, 2017 11:42 AM by Saima SM RSS

    Adding polynomial order 2 in qliksense chart

    Saima SM

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