Discussion board where members can get started with Qlik Sense.
I have a table in which one of the fields is named date. When I uploaded this to Qlik the dates read:
I'm unsure what format this is but I am able to convert this into DD/MM/YYYY using the expression Date(num#(Date,'#')).
This successfully changes the dates and they then read:
But I want to have the dates read just 01/2017, 02/2017...
Is it possible to make the date read in that way? If so, please let me know.
Thanks in advance,
Solved! Go to Solution.
So I am guessing you are doing something like this... are you?
CrossTable (MonthYear, Data)
Now you need to do this
Date(MonthStart(Num#(MonthYear)), 'MM/YYYY') as MonthYear
DROP Table Income;
Dates are stored as dual value, the number and a formatted display.
What you are seeing is the number.
in the top of the data load script, the default format is set:
change this to:
Then you can use:
Date("Date") As FormattedDate
If the date value was a value other than the first of the month, this would force it to be the first of the month. Not sure that was the question, the sample data happened to match that pattern;
In this case, MonthStart would not be necessary to get the formatted output.
Sunny is correct that you should use the MonthStart() function to make the internal value of the dates to be the same. Otherwise you will get multiple values showing "01/2017" in a listbox or chart dimension.