Linest_R2 optional value - how to use

[jpenuliar]

Hi All,

Does any one have an example of using Linest_R2 function with the optional value?

LINEST_R2 (y-value, x-value[, y0 [, x0 ]])

I am trying to get R2 when forced through origin. I have already derived R2(intercept) in R and Excel(linest function) and now only need to see if possible using qlik linest_r2 function.

Thanks for the help.

Regards,

JP

[Frank_Hartmann]

try this:

=LINEST_R2(total aggr(Y,X),X)

or

=LINEST_R2(total aggr(sum(Y),X),X)

hope this helps

[jpenuliar]

Hi Frank,

That is only evaluating the R2 of Y and X the usual way. What i am after is with optional parameters y0, x0, forcing the regression line to pass through the y-axis at a given point