5 Replies Latest reply: Dec 11, 2017 4:37 AM by Seref Keser RSS

    Usage of Excel table:different columns with same content

    Tom Müller

      Hi together,


      I've got a little issue with an excel-sheet, I created for the usage in QLIK. The sheet looks like this:



      As it can be seen, I have several columns, that contain the same content: Projekt and Zeit.

      In fact the table could look like this also:




      As it is easier for me to design the excel sheet like seen above, I would really like to keep it like it is. Is it possible to integrate this form of sheet in QLIK, so that I could tell QLIK f.e. to create the field "Projekt" as a list of all seen six columns of Projekt and elsewhise with "Zeit"?


      Thanks for the replies and best regards,

      Tom Müller