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

    Recognising multiple unique field values

    Alison Cooke

      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