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.
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: