Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Adding polynomial order 2 in qliksense chart

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

Community Browser