Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
The "Chart Properties: Expressions" contain a nice option of displaying the trendlines. For the linear trendline there is a corresponding linest family of statistical aggregation functions. However I have not found the way to do the same for other types of trendlines.
Do you know a way of getting Qlikview to calculate following trendline factors:
Polynomial of 2nd degree, Polynomial of 3rd degree, Polynomial of 4th degree,Exponential
May be there is a way to leverage VBS or JavaScript to access that calculation?
What I need to do is to see which of my customers are deviating from the (e.g. Polynomial of 3rd degree) forecast in most recent period. So in Qlikview there would be a chart with actual data vs trendline (this is already possible) and there will be a listbox with the calculated dimension "Deviation Flag".
The calculation of that Deviation Flag against forecast of Polynomial of 3rd degree is what I need to create.
Did you find a solution for this?
No, but thank's for asking.
Hi,
I hope I'm not too late.
You should see this website for the quadratic regression
Quadratic regression Calculator - High accuracy calculation
You can create variables and easily calculate the coefficients.