Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Correl with variables, calculated as an aggregate

Hi

I'd like to calculate the correlation coefficient of two variables when their value is calculated at an aggregated by "Gorup Name" .I have tried the following expression however I get all nul values. I have tried using the Group Name as a dimension too and also tried removing it. I know the variables themselves do work as I am plotting them on a scatter chart and I can see valid values. Ultimately, I want a single number to tell me what the correlation coefficient is for the two variables that can be seen in the scatter graph.

correl (<[Group Name]>vExpression_scatterX, vExpression_scatterY)

or

correl(<[Group Name]>$(vExpression_scatterX), $(vExpression_scatterY))

Hopefully this is quite a simple one to fix... we shall see!

Many thanks,

Isabel

0 Replies