This content has been marked as final.
Show 4 replies

Re: Use polynomial regression result to predict future
Guan Wang Jul 23, 2012 1:19 PM (in response to Guan Wang)Does anyone know whether this is feasible?
Thanks!

Re: Use polynomial regression result to predict future
Nagaian Krishnamoorthy Jul 23, 2012 2:06 PM (in response to Guan Wang)I think this is possible.
Try the 'axes' tab of the chart properties window.
Check the 'forecast' checkbox and
in the box below, enter the number of xaxis values you want to forecast.

Re: Use polynomial regression result to predict future
Guan Wang Jul 23, 2012 2:14 PM (in response to Nagaian Krishnamoorthy)Thanks a lot!
It there a way that can show the forcast number? The feature you mentioned is really cool, but it does not show the forcast numbers.

Re: Use polynomial regression result to predict future
Nagaian Krishnamoorthy Jul 23, 2012 3:05 PM (in response to Guan Wang)I think that by using linest_m() and linest_b() you may be able to forecast.
I am not sure how you can use polynomial regression for calculating forecast. But as Qlikview proposes a1, a2, a3, a4, values in the form of equation, you may see if you are able to capture these coefficients using a macro and then use them for forecasting.


