topic Re: Combination analysis in QlikView

Combination analysis

Fri, 10 Jul 2015 08:28:53 GMT

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

Re: Combination analysis

Agis-Kalogiannis — Fri, 10 Jul 2015 16:21:42 GMT

Hi Marketa

Here is an example.

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

Thanks

ALK

Re: Combination analysis

Kushal_Chawda — Fri, 10 Jul 2015 16:50:39 GMT

See the attached

Re: Combination analysis

Mon, 13 Jul 2015 14:41:56 GMT

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

Re: Combination analysis

Agis-Kalogiannis — Mon, 13 Jul 2015 14:47:59 GMT

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

Re: Combination analysis

Mon, 13 Jul 2015 15:46:56 GMT

Wonderful, thank you!