topic R2 value for a plot in QlikView

R2 value for a plot

Wed, 19 Oct 2011 15:16:04 GMT

I have 2 variables in my dataset and want to know how well a regression without intercept fits the data.

I predict Y by using X

so my regression formula is Y= B*X

Using Linear regression.

The measurement for the goodness of the fit is the R2.

the formula for R2=

1-(RRerr/RRtot)

see: http://en.wikipedia.org/wiki/Coefficient_of_determination

I understand the concept of regression and the formula of R2, but I can's seem to get this working in qlikview.

Anyone know how?

see trial dataset in attachment

R2 value for a plot

swuehl — Wed, 19 Oct 2011 15:48:28 GMT

You may want to take a look into the linest_XXXX function sets (search the Help for statistical aggregation functions in charts).

So maybe

=LINEST_R2(y,x)

is what you are looking for?

Re: R2 value for a plot

Thu, 20 Oct 2011 07:40:05 GMT

Your answer works thanks!

I was trying to type the whole formula for R2 myself... too tricky to make mistakes...

The only problem I still have is the following:

I want a regression without a constant.

So I figured you should type linest_r2(y,x,0).

However, this doesn't work. Neither does linest_r2(y,x,'0').

linest_r2(y,x) works though. But I guess this is the R2 of a regression of y=mx + b and not y=mx

R2 value for a plot

swuehl — Thu, 20 Oct 2011 08:14:09 GMT

In this case, I think linest_r2(y,x,0) should be used. This is also what the help says.

Specifying the y0 does work with other linest functions, if it does not work with linest_r2, I have no clue yet.

R2 value for a plot

Thu, 20 Oct 2011 08:23:52 GMT

no it does not work for linest_r2 (anyway, not in my file).

the trial dataset is attached with my first post...

R2 value for a plot

swuehl — Thu, 20 Oct 2011 11:56:29 GMT

I'll be offline for a few days.

If feasible, you may want to contact support, I think this could be a bug, it's not working as described (in the Help).

I could maybe Help you in rebuilding (like you initially tried) the expression, but not before mid of next Week.

Re: R2 value for a plot

jansen28 — Tue, 23 Dec 2014 19:17:55 GMT

Hi Kenneth, I'm working on the linest_r2 calculation. I'm using the below formula to calculate r2.

where,

vmindate = 12/30/2013

vgetfield = 06/01/2014

=LINEST_R2({<Date = {'>=$(vmindate) <=$(=vgetfield)'}>}x,y)

I get null value. Does Linest_r2 works in qlikview or Am I using incorrect calculations.

I appreciate your help Kenneth....

Regards,

Jan

Re: R2 value for a plot

Anonymous — Thu, 14 Dec 2017 11:38:36 GMT

Hi Janani,

Were you able to get value using LINEST_R2() with date condition.