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:







      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