Discussion board where members can get started with QlikView.
How can I choose to display full/long month names or week names instead of the shorter version?I have added the following:
code][SET MonthNames='jan;feb;.......SET LongMonthNames='January;February;.....SET DayNames='mo;tu;...........SET LongDayNames='Monday;Tuesday;.........
After you create this variables you can use the long name expression for names:
=date(today(), 'DD/MMMM/YYYY') will return the date with the full month name.
=date(today(),'WWWW DD/MMMM/YYYY') will return long day name, number of the day, long Month name and year
View solution in original post
Well if you want to display it instead, why are you adding a 2nd variable? Just replace the MonthNames system variable values with January, etc.
If you are using a calender you can also add them as a field, fe:
JOIN (Calendar)Load * Inline [Month, MonthName1, Januari2, Februari 3, Maart4, April 5, Mei6, Juni7, Juli8, Augustus9, September10, Oktober11, November12, December];
Or just change it into:
[SET MonthNames='January;February;.....SET DayNames='Monday;Tuesday;.........
That should also work I think, if you don't need the short names
This was exactly what I was after.