Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How can i extract the formula of a polynomial trendline?

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

0 Replies