Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Within your load-script replace Course with subfield(Course, ',') as Course.
- Marcus
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?
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.
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
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
Okay got it, I understood this to be different. and hence I came up with the second dimension.
Marcus has the right solution.
Thank you!