This content has been marked as final. Show 3 replies
My data model is very simple.
Just one table and 3 columns. It looks something like this
|Month Year||Product Name||Total Sales|
(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
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