Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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';
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);
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';
Dear Dilip,
I am using same method .
Thanks for quick response to giving suggestion on my task.
Regards
Suman
no problem. Close thread as answered if it helped
Dear Anton,
Iam trying with your expression, it's exactly working what i want to show.
Thanks for giving good suggestion.
Regards
Suman