Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
qw_johan
Contributor

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
Highlighted
Partner
Partner

How to display long weeknames and monthnames

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
Highlighted
vgutkovsky
Honored Contributor II

How to display long weeknames and monthnames

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,

Highlighted
Partner
Partner

How to display long weeknames and monthnames

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


Highlighted
Partner
Partner

How to display long weeknames and monthnames

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

Highlighted
Partner
Partner

How to display long weeknames and monthnames

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

Highlighted
qw_johan
Contributor

How to display long weeknames and monthnames

Hi Erich,

This was exactly what I was after.

Thanks