Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Add Polynomial Trendlinen order 2 in Qliksense chart

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

1 Reply
sunny_talwar

Seems like a similar thread to the other one... check my response here:

Trendline (Polynomial order 2) in Qliksense chart