# New to QlikView

Discussion board where members can get started with QlikView.

Highlighted Not applicable

## Extracting Polynomial equation formula from trendline

Hi,

I am trying to build a table with a forecast column using the values from the polynomial trendlines and then extract the formula (i.e. y = a2x^2 + a1x + b).

I know how to do this for linear trendline (y=mx+b), using:

m = LINEST_M(Aggr(sum(Xval),Yval),Yval)

b = LINEST_B(Aggr(sum(Xval),Yval),Yval)

I can then use these values in straight table to make a forecast column in my table. However, this is less acurate than the polynomial equation. Are there  equvilent functions to calculate the polynomial constants?

Dave

Tags (4)
1 Solution

Accepted Solutions MVP & Luminary

## Re: Extracting Polynomial equation formula from trendline

No, that's not possible. But you can add a polynomial trendline of 2nd to 4th degree and check the option Show Equation. If you need more statistic functions you need something like the R integration kit.

talk is cheap, supply exceeds demand
2 Replies MVP & Luminary

## Re: Extracting Polynomial equation formula from trendline

No, that's not possible. But you can add a polynomial trendline of 2nd to 4th degree and check the option Show Equation. If you need more statistic functions you need something like the R integration kit.

talk is cheap, supply exceeds demand Not applicable

Ok, thanks!