Discussion board where members can get started with QlikView.
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 ?
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.
Hi, you can add linear function with Properties/Expressions/Trendlines
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:
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
here is explanation of area calculation,
made it several times for lorentz/pareto curve or roc curve
maybe somethink like (rowno -1) * 10 as far as X is 0 to 10 ?
tell me is that suit you