Hello,
I need to calculate aprox. 5 datapoints as a forecast. I use a polynomial trendline 2 th degree. The trendline is based on aprox. 6 measured datapoints.
I can plot the trendline in the graph, using the forecast option. The problem is that i need to calculate de datapoints so i can use them in a straight table.
i've looked all over the internet and i can only find a start of a solution when using a lineair trendline, but the lineair function is not adequate enough.
Qlikview can present the formula it uses for the trendline >> option: show eqation. Is it possible to extract this formula and use it to calculate the value of the datapoints?
with regards,
Erich van den Heuvel
