Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

stumorris1
New Contributor

Using Linest to predict month end values

Hi, I'm trying to predict month end values and have got as far as getting the results from a straight table.  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.  With the file attached, I can see the value for 30th June is 98.8342, when I select June from the list box.  Can I do this without a table, or even better, generate this value in the code?

Many thanks,

Stu.

Tags (1)
Community Browser