topic Re: Trend Linear expression in QlikView

Trend Linear expression

Anonymous — Tue, 03 Jul 2018 14:31:26 GMT

Hello all,

I have a chart with 3 expressions of last year, actual year and actual month.

How could I add a Trend linear line?

I'm not using dimension in this chart.

Tks!

Re: Linear expression

ogautier62 — Tue, 03 Jul 2018 14:43:28 GMT

what sort of line ?

horizontal ?

trend ?

regards

Re: Linear expression

Anonymous — Tue, 03 Jul 2018 14:44:29 GMT

trend

Re: Trend Linear expression

ogautier62 — Tue, 03 Jul 2018 14:51:33 GMT

and how is it calculated ?

average ?

linear regression ?

Re: Trend Linear expression

Anonymous — Tue, 03 Jul 2018 14:54:55 GMT

Linear. LIke this:

This is the expression:

1-(SUM({1<MACHINE_TYPE={'HV'},YEAR_21_20={'$(vLast_year_2120)'}>}MEC_HR_REAL_VER)/

SUM({1<MACHINE_TYPE={'HV'},YEAR_21_20={'$(vLast_year_2120)'}>}PLAN_HR_REAL_VER))

Re: Trend Linear expression

ogautier62 — Tue, 03 Jul 2018 15:01:53 GMT

in expression, check this to draw line :

you get coefficient with function linest_m and linest_b

Re: Trend Linear expression

Anonymous — Tue, 03 Jul 2018 15:05:49 GMT

It's already checked for the 3 expression but doesn't show the line.

Re: Trend Linear expression

ogautier62 — Tue, 03 Jul 2018 15:16:14 GMT

you must have a dimension,

if not, you have to calculate manually with linest_ and the three expressions

Re: Trend Linear expression

Anonymous — Tue, 03 Jul 2018 15:19:58 GMT

Ok. linest as an expression or reference line?

Do you have any example of how to use linest in this situation?

Re: Trend Linear expression

ogautier62 — Tue, 03 Jul 2018 15:49:59 GMT

with Monthyear in dimension,

and just one expression :

1-(SUM({1<MACHINE_TYPE={'HV'}}>}MEC_HR_REAL_VER)/

SUM({1<MACHINE_TYPE={'HV'}}>}PLAN_HR_REAL_VER))

it should work

Re: Trend Linear expression

Anonymous — Tue, 03 Jul 2018 17:57:19 GMT

If I put month dimension, it shows all months of the years.

I just need 2017, 2018 and the last month (07/2018).

Follow the .qvw.