Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
Not applicable

Format Date

I want to show just the first 3 letters of each month but when I use monthname show the intere name of the month.

I try to use Date(date, 'MMM/yyyy') and is also showing the entire name of the month.

There are some setting I have to change?

Thanks in advance.

Tags (1)
1 Solution

Accepted Solutions
Highlighted

Re: Format Date

Make sure you have this in your load script:

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';


Capture.PNG

View solution in original post

2 Replies
Highlighted

Re: Format Date

Make sure you have this in your load script:

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';


Capture.PNG

View solution in original post

Highlighted
Not applicable

Re: Format Date

Thank you