Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to enable Degrees of polynomial in Straight Table. I know these features are available in lines charts but I want to have these forecast to be shown in a table also. For Linear Regression I'm able to get in the table but for other degrees of polynomial Qlikview just shows the output same as Liner Regression in the table.
I have posted the sample data (text format) which has 2 columns y-axis would be the column name "PoSUnits" and X-axis is "WeekName(Date)"
Below is the script from the Qlikview editor
LOAD
Date,
Year(Date),
Week(Date),
Month(Date),
WeekDay(Date),
WeekEnd(Date),
WeekName(Date),
WeekName(Date)as "Fiscal Year Week Date",
WeekStart(Date),
PoSUnits,
WeekYear(Date)
From
[C:\Sample_Data_SN - Dummy Data.txt]
(txt, utf8, embedded labels, delimiter is ',', msq);
A degree in a polynomial function is the greatest exponent of that equation, which determines the most number of solutions that a function could have and the most number of times a function will cross the x-axis when graphed.