topic Re: Correlation on same variable in QlikView

Correlation on same variable

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Correlation on same variable

luismadriz — Wed, 20 Dec 2017 01:23:21 GMT

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

Re: Correlation on same variable

ravikumar_iyana — Wed, 20 Dec 2017 03:09:54 GMT

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