topic Using Linest to predict month end values in QlikView https://community.qlik.com/t5/QlikView/Using-Linest-to-predict-month-end-values/m-p/1099804#M632561 <HTML><HEAD></HEAD><BODY><P>Hi, I'm trying to predict month end values and have got as far as getting the results from a straight table.&nbsp; I want to be able to get the value for y = mx + b, in this case for the last day in June, based only on the 'DayResult' figures recorded in June.&nbsp; With the file attached, I can see the value for 30th June is 98.8342, when I select June from the list box.&nbsp; Can I do this without a table, or even better, generate this value in the code?</P><P></P><P>Many thanks,</P><P></P><P>Stu.</P></BODY></HTML> Wed, 06 Jul 2016 11:12:38 GMT Anonymous 2016-07-06T11:12:38Z Using Linest to predict month end values https://community.qlik.com/t5/QlikView/Using-Linest-to-predict-month-end-values/m-p/1099804#M632561 <HTML><HEAD></HEAD><BODY><P>Hi, I'm trying to predict month end values and have got as far as getting the results from a straight table.&nbsp; I want to be able to get the value for y = mx + b, in this case for the last day in June, based only on the 'DayResult' figures recorded in June.&nbsp; With the file attached, I can see the value for 30th June is 98.8342, when I select June from the list box.&nbsp; Can I do this without a table, or even better, generate this value in the code?</P><P></P><P>Many thanks,</P><P></P><P>Stu.</P></BODY></HTML> Wed, 06 Jul 2016 11:12:38 GMT https://community.qlik.com/t5/QlikView/Using-Linest-to-predict-month-end-values/m-p/1099804#M632561 Anonymous 2016-07-06T11:12:38Z