Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
sumanyedla121
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
avkeep01
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
dilipranjith
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);

avkeep01
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

sumanyedla121
Contributor III
Contributor III

Dear Dilip,

I am using same method .

Thanks for quick response to giving suggestion on my task.

Regards

Suman

dilipranjith
Partner
Partner

no problem. Close thread as answered if it helped

sumanyedla121
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