Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
stumorris1
Contributor
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.

0 Replies