topic Re: Trendline slope in QlikView

Trendline slope

Wed, 13 May 2015 04:11:52 GMT

Hello

Is there any possibility of having in the table slope of a trendline?

I've got amount of sales in time and i'd like to have % value of the trendline in a table so i could tell if sales are increasing or decreasing.

Re: Trendline slope

sushil353 — Wed, 13 May 2015 04:16:09 GMT

Hi,

it is better if you could tell the specific requirement with an example..

and there are some trendline option available in your chart property>expression>Trendline (lower left corner).

HTH

sushil

Re: Trendline slope

Wed, 13 May 2015 04:23:51 GMT

Ok, some kind of example for better idea of what i want.

I've got this chart and i want blue line of trend to be in table.

Maybe % of slope, maybe there's some method to get value of starting and ending point so i could see if it's going up or down.

Re: Trendline slope

prasadcm — Wed, 13 May 2015 05:37:24 GMT

Hi Zelman15,

Do u want something like this?

Regards,

Prasad

Re: Trendline slope

Wed, 13 May 2015 06:23:05 GMT

I have already tried doing something like this and it's not what i'm looking for.

I have to tell if trending line is ascending or descending.

If there was possibility of putting trending line into this chart, it would be good enought for me, but i haven't found this option anywhere.

Re: Trendline slope

antoniotiman — Wed, 13 May 2015 08:51:03 GMT

Hi,

I think can't be done what You want.

However, You can use ColorMix1() in background color of expression

like this

You can use wizard of ColorMix1()

or in background color You can use expression like If(Expr > Average,Green(),Red())

Regards,

Antonio

Re: Trendline slope

jvitantonio — Wed, 13 May 2015 10:17:07 GMT

Hello Zelman,

This is possible and it's very simple. You can use the function called "Linest_m". Linest_m returns the slope of a linear regression defined by the equation y = mx + b.

So for example, you can have an expression in your table like this:

LINEST_M(aggr(nodistinct sum(Sales), Month, Product), Month)

If Linest_M > 0 then you have a positive trend, and if it's < 0 you have a negative trend .If it's 0, then the slope is undefined meaning that all data points (x, y) are equal.

You need to modify the aggr() function depending on what dimensions you want to aggregate your values.

I'm attaching an example.

JV.