6 Replies Latest reply: Nov 7, 2017 4:01 AM by Shraddha Gajare RSS

    Date format from CSV

    Wai Meng Leong

      Hi community,

       

      I have a problem with a date field (maybe it isn't even processed as a Date field when loaded in Qlik.)

      This is the csv view of the field.

      qlikcap.JPG

       

      So I am trying to get the Month and Year from this field and I have tried all the following in load script (because the field just doesn't read as a date field.

      script.JPG

      This is what I see in the dashboard view:

      dash.JPG

      Lastly, here's the SETTINGS (I have tried a few date formats)

      date.JPG

      Would greatly appreciate any help! Thank you in advance.

       

      Regards,

      Wai Meng