Combination analysis

[#1]

Hello,

I was wondering if someone could help. I have data on students and the courses they take; two columns, one is student ID, the other is subject name - please see sample data attached (in reality it's 900 rows). As each student takes 2 to 4 courses, the student IDs are repeated on several lines. I want to find out what the most popular combinations of subjects are, i.e. how many students take each combination. I want to compare all the courses that the students take, i.e. if someone takes 4 course, consider all of them: student taking English and maths only would NOT be grouped together with a student taking English, maths and history.

I'd greatly appreciate some insight on how to deal with this in QlikView.

Many thanks,

Marketa

[Agis-Kalogiannis]

Hi Marketa

Here is an example.

Can you please let me know if this is what you need?

Thanks

ALK

[Kushal_Chawda]

See the attached

[#4]

Thank you both very much for you help. Neither option is exactly what I needed, but ALK's is nearly there.The only thing that needs to be changed there is to get the number of DISTINCT students for each combinations to get the following:

English, History, Maths	2
English, History, Sociology, Psychology	1
English, Maths, History	1
Business, Maths	1
Business, Maths, Further Maths, English	1
English, Maths	1

Could you please help me adjust that accordingly?

Many thanks,

Marketa

[Agis-Kalogiannis · Accepted solution]

Here it is. 🙂

The left join messed up the counters. So we have two options there...

1. Don't join the tables

2. Create a separate counter table

I just removed the left join.

Thanks

ALK

[#6]

Wonderful, thank you!