topic Re: Linear Regression in QlikView https://community.qlik.com/t5/QlikView/Linear-Regression/m-p/1251350#M395970 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>=If(Sum(Cost) &gt; 0, Sum(Cost),</STRONG></P><P><STRONG>LINEST_M(TOTAL &lt;Country&gt; Aggr(Sum(Cost), Country, Month), Month)*Month + LINEST_B(TOTAL &lt;Country&gt;Aggr(Sum(Cost), Country, Month), Month))</STRONG></P></BODY></HTML> Wed, 08 Mar 2017 13:04:21 GMT sunny_talwar 2017-03-08T13:04:21Z Linear Regression https://community.qlik.com/t5/QlikView/Linear-Regression/m-p/1251349#M395969 <HTML><HEAD></HEAD><BODY><P>Hi Guys,</P><P></P><P>I want to create a bar chart which will project the data for next 4 months. I am aware of the fact that linest_m and linest_b can be used for linear regression. However, I am not able to do that properly and data seems incorrect. </P><P></P><P>I am attaching the input file. The file contains data from Nov-2016 to Mar-2017 data for three different countries. In the Bar chart, for each country, for next 4 months i.e. from Apr-2017 to July-2017, data needs to be projected. Can anyone help me with this.</P><P></P><P>Thanks.</P></BODY></HTML> Wed, 08 Mar 2017 12:48:53 GMT https://community.qlik.com/t5/QlikView/Linear-Regression/m-p/1251349#M395969 sohb2015 2017-03-08T12:48:53Z Re: Linear Regression https://community.qlik.com/t5/QlikView/Linear-Regression/m-p/1251350#M395970 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>=If(Sum(Cost) &gt; 0, Sum(Cost),</STRONG></P><P><STRONG>LINEST_M(TOTAL &lt;Country&gt; Aggr(Sum(Cost), Country, Month), Month)*Month + LINEST_B(TOTAL &lt;Country&gt;Aggr(Sum(Cost), Country, Month), Month))</STRONG></P></BODY></HTML> Wed, 08 Mar 2017 13:04:21 GMT https://community.qlik.com/t5/QlikView/Linear-Regression/m-p/1251350#M395970 sunny_talwar 2017-03-08T13:04:21Z