Reference Line

sat_tok52 — Mon, 04 Jul 2016 07:17:52 GMT

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

Re: Reference Line

migueldelval — Mon, 04 Jul 2016 07:37:16 GMT

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