Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to get a trend line equation?

Immagine.jpg

I have a chart with two expressions, the first one is the main expression (blue line) and the other one is a customized trend line, basically a line which links the first value at "gen 2012" to the last value at "lug 2012". In order to show the equation of the red line I activated the trend line on the second expression and checked the "show equation" option. The user can select the range of months so the X values in the chart are dynamic, and that's the reason why I used the rowNo() function to get the X value (in order to make the equation work I have to assume that "gen 2012" is X=0 and "lug 2012" is X=7).

What I need to do is to get the m and the b values of the line (m=11568, b=312030). I tried to use the linest_m and linest_b functions in this form:

linest_m(total aggr(Y,X),X)

linest_b(total aggr(Y,X),X)

If I write RowNo() instead of the X all I obtain is a crash of QlikView. Do you know any solutions for it?

0 Replies