Discussion board where members can get started with Qlik Sense.
My data model is very simple.
Just one table and 3 columns. It looks something like this
(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:MMS
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
Go to Solution.
Please check the X-axis Continuous option.
Put Continuous option in Auto mode.
You will find this option under
Appearance -> X-axis.
Try this in script,
Date(Floor(Num(Date)),'MMM-YY') as [Month Year]
you can also use ceil instead of Floor based on your requirement.