Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

How to convert Month numbers "01" to "January"

Dear Qlik,

I want to show month numbers into full month names like 01 to January.

please give me a suggestion on my task. I attached sample excel file  and in that i want to show output.

1 Solution

Accepted Solutions
Partner
Partner

Hi Suman,

Try DATE(MONTHSTART([DateField]),'MMMM') AS Month

You can adjust the system variable (at the beginnen of your script)

SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';

View solution in original post

5 Replies
Partner
Partner

Modify your environment variables and use month function. like below

SET MonthNames='January;February;March;April;May;June;July;August;September;October;November;December';

Load *,

Month(Date) as month;

LOAD Date

FROM

[.\Dates.xlsx]

(ooxml, embedded labels, table is Sheet1);

Partner
Partner

Hi Suman,

Try DATE(MONTHSTART([DateField]),'MMMM') AS Month

You can adjust the system variable (at the beginnen of your script)

SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';

View solution in original post

Contributor III
Contributor III

Dear Dilip,

I am using same method .

Thanks for quick response to giving suggestion on my task.

Regards

Suman

Partner
Partner

no problem. Close thread as answered if it helped

Contributor III
Contributor III

Dear Anton,

Iam trying with your expression, it's exactly working what i want to show.

Thanks for giving good suggestion.

Regards

Suman