7 Replies Latest reply: Jun 21, 2017 8:59 AM by Alison Cooke RSS

    Recognising multiple unique field values

    Alison Cooke



      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,