Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Recognising multiple unique field values

Hello,

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

Screenshot (2).png

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

Screenshot (3).png

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:

Screenshot (4).png

Thank you in advance,

Alison

Tags (1)
1 Solution

Accepted Solutions

Re: Recognising multiple unique field values

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

7 Replies

Re: Recognising multiple unique field values

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

- Marcus

Not applicable

Re: Recognising multiple unique field values

Hello Marcus,

Thank you for your response.

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

Screenshot (5).png

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

umartareen
Contributor

Re: Recognising multiple unique field values

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.

Re: Recognising multiple unique field values

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

MVP
MVP

Re: Recognising multiple unique field values

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
Contributor

Re: Recognising multiple unique field values

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

Marcus has the right solution.

Not applicable

Re: Recognising multiple unique field values

Thank you!