Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Showing Correlation Coefficient in Chart same column

In this thread Showing Correlation Coefficient in Chart explain how calculating Correlation Coefficient in QLikview:

correl ([{set_expression}] [ total [<fld {,fld}>] ] x-expression, y-expression )

example:

XY
1813
1715
1514
1613
149

Correl(,) = 0.624037721

But my data is this:

MetricMeasure
X18
X17
X15
X16
X14
Y13
Y15
Y14
Y13
Y9

How can calculate Correlation, if it show error: =Correl({$<Metric={'X'}>}Measure,{$<Metric={'Y'}>}Measure)

Thanks for your help

1 Reply
Anonymous
Not applicable
Author

I am also having this issue, can you use $ expansion to calculate correlations between specific measures? You should be able to.