Qlik Community

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?

Thanks in advance,

Dave

1 Solution

Accepted Solutions
MVP & Luminary
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

View solution in original post

2 Replies
MVP & Luminary
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

View solution in original post

Not applicable

Re: Extracting Polynomial equation formula from trendline

Ok, thanks!