6 Replies Latest reply: Nov 11, 2015 9:21 AM by Jason Wills RSS

    Extracting Month from a string.

    Jason Wills

      Hi All,

       

      new to Qlik Sense, but loving it so far - however, I am stuck on one thing I was hoping you could help with.

       

      I have a date from a column in excel which is in this format:

      DD-MMM-YYYY

       

      e.g.

       

      11-NOV-2015

       

      what I am trying to do, is in the data load editor is create a new column with the month in.

       

      I have the following so far:

       

      Trim(SubField(columnName,'-',2)) as Month,

       

      This gets me NOV into a new field - however, if I try to wrap that inside a Month function I get nothing imported.

       

      Any help is greatly appreciated.

       

      Many Thanks

       

      Jason