Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
Very much a leaner on Qlikview so please bear with me.
My data is a table of survey results where the table is normalised, i.e.
RespID Type QID Score
0001 Apple Q1 10
0001 Apple Q2 4
0001 Apple Q3 5
0001 Apple Q4 3
0002 Orange Q1 9
0002 Orange Q2 5
and so on
I am trying to calculate the correlation between QID "Q1" and the other questions. The examples I found on the forum seem to be looking at 2 separate variables and my lack of Qlikview knowledge means I don't know how to adapt to fit!
My "Plan B" is to calculate the correlations in Excel and load them as a secondary file but it would be really useful to be able to filter down into the results (in my example above by "Apple" and "Orange".)
Would someone be able to point me in the right direction?!
Many thanks
Hi Paul,
I think you should calculate an example in Excel and then show the results in the post with the algorithms. This may help you get few possible responses,
Cheers,
Luis
Hi Paul,
Upto my understanding u required for count Individual apple,orange
May be below expression is helpful to u
1) count({<QIP={'Apple'}>}QIP)
2) COUNT({<QIP={'Orange'}>}QIP)
Thanks,
Ravi