topic Correl function with aggregation in QlikView

Correl function with aggregation

Mon, 14 Mar 2016 22:09:33 GMT

Hello,

I want to calculate the correlation between two dataset. How can I use a set analysis in the correl expression. This is what I tried, but that doesn't work:

Correl(avg({$< Variable = {"P02.01"}>}TOTAL #score),avg({$< Variable = {"P03.01"}>}TOTAL #score))

Who can help?

Re: Correl function with aggregation

swuehl — Mon, 14 Mar 2016 22:30:05 GMT

The Correl() function should operate on pairs of dimensional data values, not on a pair of scalar values.

I think you would need to apply advanced aggregation, something like

Correl(

Aggr( avg({$< Variable = {"P02.01"}>}#score), Dimension) ,Aggr(avg({$< Variable = {"P03.01"}>}#score), Dimension)

)