topic Re: Linest_R2 Function Usage in QlikView

Linest_R2 Function Usage

anushree1 — Mon, 18 Dec 2017 12:18:12 GMT

HI,

I have been using the Linest_R2 for the first time , I do understand it gives the co relation between 2 values.

I have the y and x values which are to be considered within Linest_R2 function as sum(y) and sum(x) , but when i apply this i get an error stating nested aggregation is not allowed.

So could someone guide me how sum(y) and sum(x) values be used within Linest_R2 function

Re: Linest_R2 Function Usage

anushree1 — Tue, 19 Dec 2017 07:51:34 GMT

Does anyone have any suggestions for the above Query

Re: Linest_R2 Function Usage

Frank_Hartmann — Tue, 19 Dec 2017 09:56:19 GMT

try this:

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

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

hope this helps