Recognising multiple unique field values

[#1]

Hello,

I have a data set that looks like this, where I have selected multiple items from a drop down list.

When I upload this data it is, perhaps predictably, read like this:

As you may have guessed, this is not how I want the data to be interpreted. I want to be able to convey that an individual is simultaneously enrolled in a Design course as well as a Manufacturing course and so on...

Is it possible to command Qlik to interpret the data in my desired way in the data load editor. Or could I prep the data in such a way as to facilitate Qlik reading of the data in this manner. Other than simply doing this:

Thank you in advance,

Alison

[marcus_sommer]

Within your load-script replace Course with subfield(Course, ',') as Course.

- Marcus

[#3]

Hello Marcus,

Thank you for your response.

I have done so and I am now left with this:

So it's better, but not quite right. Any ideas on how to solve this?

[umartareen]

Once you have Marcus's solution applied, you will have to add ID as a dimension into the chart.

You should have two dimensions then,

ID

Course

Place ID before Course, so ID should be the first dimension.

[marcus_sommer · Accepted solution]

I see there are sometimes spaces between your values and the comma-delimiter. If possible try to clean it within your source and if not add just a trim-statement to your split, like:

Course with trim(subfield(Course, ',')) as Course

- Marcus

[sunny_talwar]

Try adding two more functions

1) Capitalize (May not be needed, but just in case)

2) Trim - to remove any extra spaces

Capitalize(Trim(Subfield(Course, ','))) as Course

[umartareen]

Okay got it, I understood this to be different. and hence I came up with the second dimension.

Marcus has the right solution.

[#8]

Thank you!