topic Re: Month Name from Month Number in QlikView

Month Name from Month Number

john_s_w_wood — Thu, 14 May 2015 10:31:41 GMT

Has anyone got a slick way of converting a month number to a month name?

I either end up using an inline table ( generally as a mapping / applymap)

1,Jan

2,Feb

etc

or a horrible string function pick(monthno, 'Jan', 'Feb', etc)

Thanks

petter — Thu, 14 May 2015 10:36:25 GMT

You can use this:

=SubField(MonthNames,';',1)

1 gives Jan ... and so forth...

MonthNames should be predefined according to your settings in Windows and at the top of your load script.

So in your case it should be:

=SubField(MonthNames,';',monthno)

tresB — Thu, 14 May 2015 10:37:15 GMT

Month(MakeDate(1,MonthNum))

Anonymous — Thu, 14 May 2015 10:38:17 GMT

best way is to do a inline mapping table load and use applymap

Thanks

BKC

antoniotiman — Thu, 14 May 2015 10:39:42 GMT

Month(Date#(4,'MM'))

Gabriel — Thu, 14 May 2015 10:43:56 GMT

Hi,

Try this script

load
Month(MakeDate(Today(), MonthNumber, 1)) AS Month_Name,
* Inline [

MonthNumber
1
2
3
4
5
6
7
8
9
];

john_s_w_wood — Thu, 14 May 2015 10:48:46 GMT

Thanks Folks - All great answers

luizcdepaula — Mon, 01 Feb 2016 21:15:31 GMT

This worked perfectly for me. Thanks.