Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guru's,
What is the difference between Trendlines Avg check box and Reference line Avg Calculation in qlikview,is both are same? any help.
Thanks,
Sateesh.T
Hi Sateesh,
I´ve copied next text from QlikView Reference Manual. I hope that it helps you.
If you need more information, ask me.
Trend lines
In selected QlikView charts expression plots can be complemented
or replaced by statistical trend lines. Trend lines can only be displayed
in scatter charts, line charts and in bar/combo charts with
maximally one dimension and one expression shown as bars. For
other types of charts, the settings in the Trend lines box are unavailable
and have no effect. In scatter charts the data points are treated
as if y=f(x). For bar, line and combo charts it is allowed to deselect
all options under Plot Options and still add trend lines, which will
then be plotted without the underlying data points. Trend lines in
bar, line and combo charts may be extrapolated by specifying a forecast
and/or backcast interval (Axes page). The extrapolated lines
will be dotted. Trend lines in charts with a discrete x-axis will be
shown as lines with symbols. On a continuous axis only the line will
be shown.
Average
The average is plotted as a straight line.
Linear
A linear regression line is plotted.
Polynomial of 2nd degree
A polynomial trend line of the second degree is plotted.
Polynomial of 3rd degree
A polynomial trend line of the third degree is plotted.
Polynomial of 4th degree
A polynomial trend line of the fourth degree is plotted.
Exponential
An exponential trend line is plotted.
Show Equation
If this check box is marked for a specific expression, the
expression’s trend lines will be complemented by the trendline
equation expressed as text in the chart.
Regards
Miguel del Valle