topic Re: How to add a linear function in graph in QlikView

How to add a linear function in graph

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I would like to add the linear regression y=x to my existing graph:

Also, would you know a way to calculate the area under the curve ?

Many thanks,

Lea

Re: How to add a linear function in graph

buzzy996 — Wed, 30 May 2018 14:39:42 GMT

i do not think so , directly not possible..,so lets wait for some one reply

if u r asking any statistical tools (like R),so u can map and do whatever u need.

Re: How to add a linear function in graph

sergio0592 — Wed, 30 May 2018 14:41:34 GMT

Hi, you can add linear function with Properties/Expressions/Trendlines

Re: How to add a linear function in graph

Anonymous — Wed, 30 May 2018 15:01:21 GMT

Hi,

I need to add the linear function x=y which is not connected to my expression.

I would like to create another linear trend in the same graph which is equal to:

X, Y,

0, 0%

1, 10%

2, 20%,

3, 30%,

4, 40%

5, 50%

6, 60%,

7, 70%,

8, 80%

9, 90%

10, 100%

Re: How to add a linear function in graph

ogautier62 — Wed, 30 May 2018 15:17:28 GMT

Hi,

between two deciles :

the area (approx) is

(y + below(y))/2 * 1 ( 1 = diff between two decile)

you sum this expression and you have the area under the curve

if you want to do this for your linear regression : look at linest_ functions

you can use too 1/100 fractile to be more precise

regards

Re: How to add a linear function in graph

ogautier62 — Thu, 31 May 2018 11:32:35 GMT

Re: How to add a linear function in graph

ogautier62 — Thu, 31 May 2018 11:39:46 GMT

here is explanation of area calculation,

made it several times for lorentz/pareto curve or roc curve

for y=x

maybe somethink like (rowno -1) * 10 as far as X is 0 to 10 ?

tell me is that suit you