topic How to get Equation and value R when I marked Linear in Trendlines in QlikView https://community.qlik.com/t5/QlikView/How-to-get-Equation-and-value-R-when-I-marked-Linear-in/m-p/209034#M64181 <HTML><HEAD></HEAD><BODY><P>I believe the equation for the trend line for a set of points (X,Y) is this:</P><P style="padding-left:30px;">Y = linest_m(Y,X)*X + linest_b(Y,X)</P><P>I've done that before to be able to mouse over the trend line and see the value at that point.</P><P>By R value, I think Ben means the correlation coefficient, which would be the correl() function, but it doesn't look like you needed that, though I do think it's important to show at least the correlation when making predictive models. In some cases, you may get a prediction, but there's no reason to believe it because the data is at best very loosely correlated.</P></BODY></HTML> Wed, 24 Nov 2010 22:41:36 GMT johnw 2010-11-24T22:41:36Z How to get Equation and value R when I marked Linear in Trendlines https://community.qlik.com/t5/QlikView/How-to-get-Equation-and-value-R-when-I-marked-Linear-in/m-p/209032#M64179 <HTML><HEAD></HEAD><BODY><P>Hello, everyone.</P><P>I created a bar chart and markd Linear in Trendlines, it showed me the equation in chart.</P><P>But how can I get this equation and value R?</P><P></P><P>Thanks....</P></BODY></HTML> Tue, 12 Jan 2010 14:20:23 GMT https://community.qlik.com/t5/QlikView/How-to-get-Equation-and-value-R-when-I-marked-Linear-in/m-p/209032#M64179 2010-01-12T14:20:23Z How to get Equation and value R when I marked Linear in Trendlines https://community.qlik.com/t5/QlikView/How-to-get-Equation-and-value-R-when-I-marked-Linear-in/m-p/209033#M64180 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P>I'm trying to use the equation to get the next value, so I need the linear equation (via macro, maybe).</P><P>Did you find the way?</P><P>Regards<BR />Julian</P><P></P></BODY></HTML> Wed, 24 Nov 2010 20:51:07 GMT https://community.qlik.com/t5/QlikView/How-to-get-Equation-and-value-R-when-I-marked-Linear-in/m-p/209033#M64180 2010-11-24T20:51:07Z How to get Equation and value R when I marked Linear in Trendlines https://community.qlik.com/t5/QlikView/How-to-get-Equation-and-value-R-when-I-marked-Linear-in/m-p/209034#M64181 <HTML><HEAD></HEAD><BODY><P>I believe the equation for the trend line for a set of points (X,Y) is this:</P><P style="padding-left:30px;">Y = linest_m(Y,X)*X + linest_b(Y,X)</P><P>I've done that before to be able to mouse over the trend line and see the value at that point.</P><P>By R value, I think Ben means the correlation coefficient, which would be the correl() function, but it doesn't look like you needed that, though I do think it's important to show at least the correlation when making predictive models. In some cases, you may get a prediction, but there's no reason to believe it because the data is at best very loosely correlated.</P></BODY></HTML> Wed, 24 Nov 2010 22:41:36 GMT https://community.qlik.com/t5/QlikView/How-to-get-Equation-and-value-R-when-I-marked-Linear-in/m-p/209034#M64181 johnw 2010-11-24T22:41:36Z How to get Equation and value R when I marked Linear in Trendlines https://community.qlik.com/t5/QlikView/How-to-get-Equation-and-value-R-when-I-marked-Linear-in/m-p/209035#M64182 <HTML><HEAD></HEAD><BODY><P>Hi John.</P><P>Thank you for your reply. Do you have any example of that? how to use it?</P><P>I have one Bar Chart, with Month as a Dimension and Sum(Sales) as Expression. How can I use what you said to find the equation and the next value (projection)?</P><P>Best regards<BR />Julian</P></BODY></HTML> Thu, 25 Nov 2010 11:40:45 GMT https://community.qlik.com/t5/QlikView/How-to-get-Equation-and-value-R-when-I-marked-Linear-in/m-p/209035#M64182 2010-11-25T11:40:45Z How to get Equation and value R when I marked Linear in Trendlines https://community.qlik.com/t5/QlikView/How-to-get-Equation-and-value-R-when-I-marked-Linear-in/m-p/209036#M64183 <HTML><HEAD></HEAD><BODY><P>OK, attached is an example with a couple different ways of displaying the forecast. It turned out to be more complicated than I showed since you don't just have two fields, but rather a field and an expression. Here's how it ended up:</P><P style="padding-left:30px;">linest_m(total aggr(sum(Sales),Month),Month)*Month<BR />+linest_b(total aggr(sum(Sales),Month),Month)</P></BODY></HTML> Tue, 30 Nov 2010 00:02:32 GMT https://community.qlik.com/t5/QlikView/How-to-get-Equation-and-value-R-when-I-marked-Linear-in/m-p/209036#M64183 johnw 2010-11-30T00:02:32Z How to get Equation and value R when I marked Linear in Trendlines https://community.qlik.com/t5/QlikView/How-to-get-Equation-and-value-R-when-I-marked-Linear-in/m-p/209037#M64184 <HTML><HEAD></HEAD><BODY><P>That's so great!!!!!!</P></BODY></HTML> Tue, 30 Nov 2010 14:55:26 GMT https://community.qlik.com/t5/QlikView/How-to-get-Equation-and-value-R-when-I-marked-Linear-in/m-p/209037#M64184 2010-11-30T14:55:26Z