Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qw_johan
Creator
Creator

How to display long weeknames and monthnames

Hi,

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;.........

Thanks


1 Solution

Accepted Solutions
erichshiino
Partner - Master
Partner - Master

After you create this variables you can use the long name expression for names:

for example:

=date(today(), 'DD/MMMM/YYYY') will return the date with the full month name.

The expression:

=date(today(),'WWWW DD/MMMM/YYYY') will return long day name, number of the day, long Month name and year

Regards,

View solution in original post

5 Replies
vgutkovsky
Master II
Master II

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.

Regards,

Anonymous
Not applicable

If you are using a calender you can also add them as a field, fe:

JOIN (Calendar)
Load * Inline [
Month, MonthName
1, Januari
2, Februari
3, Maart
4, April
5, Mei
6, Juni
7, Juli
8, Augustus
9, September
10, Oktober
11, November
12, December];


erichshiino
Partner - Master
Partner - Master

After you create this variables you can use the long name expression for names:

for example:

=date(today(), 'DD/MMMM/YYYY') will return the date with the full month name.

The expression:

=date(today(),'WWWW DD/MMMM/YYYY') will return long day name, number of the day, long Month name and year

Regards,

Anonymous
Not applicable

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 Smile

qw_johan
Creator
Creator
Author

Hi Erich,

This was exactly what I was after.

Thanks