3 Replies Latest reply: Aug 25, 2017 12:11 AM by ishan Bhatt RSS

    Line chart dimension keep showing time instead of month

    Lokesh Patel

      Hi Guys,

       

      My data model is very simple.

       

      Just one table and 3 columns. It looks something like this

       

      Month YearProduct NameTotal Sales
      01-05-2017Milk500
      01-05-2017Bread600
      01-06-2017Milk700
      01-06-2017Bread900
      01-07-2017Milk300
      01-07-2017Bread500

       

      (Date Format: DD-MM-YYYY)

       

      When I create a line chart in qlik sense and select [Month Year] as dimension.. then it automatically converts it into  YYYY-MM-DD HH:MM:SS


      line chart.png

      How to ensure that the dimension would only show as month year (MMM-YY) ?

       

      I have tried putting dimension as =Date([Month Year],'MMM-YY') but still does not work