topic How to get a trend line equation? in QlikView https://community.qlik.com/t5/QlikView/How-to-get-a-trend-line-equation/m-p/658199#M240178 <HTML><HEAD></HEAD><BODY><P><IMG alt="Immagine.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/61248_Immagine.jpg" style="width: 620px; height: 547px;" /></P><P></P><P>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).</P><P></P><P>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:</P><P></P><P>linest_m(total aggr(Y,X),X)</P><P>linest_b(total aggr(Y,X),X)</P><P></P><P>If I write RowNo() instead of the X all I obtain is a crash of QlikView. Do you know any solutions for it?</P></BODY></HTML> Thu, 26 Jun 2014 09:35:19 GMT 2014-06-26T09:35:19Z How to get a trend line equation? https://community.qlik.com/t5/QlikView/How-to-get-a-trend-line-equation/m-p/658199#M240178 <HTML><HEAD></HEAD><BODY><P><IMG alt="Immagine.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/61248_Immagine.jpg" style="width: 620px; height: 547px;" /></P><P></P><P>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).</P><P></P><P>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:</P><P></P><P>linest_m(total aggr(Y,X),X)</P><P>linest_b(total aggr(Y,X),X)</P><P></P><P>If I write RowNo() instead of the X all I obtain is a crash of QlikView. Do you know any solutions for it?</P></BODY></HTML> Thu, 26 Jun 2014 09:35:19 GMT https://community.qlik.com/t5/QlikView/How-to-get-a-trend-line-equation/m-p/658199#M240178 2014-06-26T09:35:19Z