# New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Highlighted
Not applicable

## Combination analysis

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

Tags (1)
1 Solution

Accepted Solutions
Employee

## Re: Combination analysis

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

5 Replies
Employee

## Re: Combination analysis

Hi Marketa

Here is an example.

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

Thanks

ALK

MVP

See the attached

Not applicable

## Re: Combination analysis

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

Many thanks,

Marketa

Employee

## Re: Combination analysis

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

Not applicable

## Re: Combination analysis

Wonderful, thank you!