topic Re: Linest_R2 optional value - how to use in QlikView

Linest_R2 optional value - how to use

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

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,

Re: Linest_R2 optional value - how to use

Frank_Hartmann — Mon, 01 Jan 2018 12:02:48 GMT

try this:

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

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

hope this helps

Re: Linest_R2 optional value - how to use

jpenuliar — Mon, 01 Jan 2018 14:37:59 GMT

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