Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
laznfin1
Contributor
Contributor

Correlation on same variable

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

2 Replies
luismadriz
Specialist
Specialist

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

ravikumar_iyana
Creator
Creator

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