3 Replies Latest reply: Jun 8, 2018 9:39 AM by Natalya Khorosheva RSS

    How to convert month in format 'Jan' то а specific date during load

    Natalya Khorosheva

      Hi all!

       

      I have loaded the file wich has next structure:

      IndicatorPlantJanFeb...
      Indicator name 1plant12034
      Indicator name 2plant23012

       

       

      Using crosstable function during load.

      Crosstable (KPIMonth,value,6)

      LOAD

          Indicator,

          Plant,

          Jan,

          Feb,

            ....

      Now I need to make Qlik Sense read Jan like a date (for example 11/01/18)

      is there a way to do it?

       

      The simplest is to create table with monthname and date and join them... but it's not the best I think...

      KPIMonthDate
      Jan11/01/18

      Can anyone help me with it?

      Oh yeah and I am learner so please explain it like if you do it to an idiot )