topic Re: make number to month name in QlikView

make number to month name

Tue, 14 Aug 2012 11:30:14 GMT

Hi,

does anyone now if I can create out of a number a month name??

example:

8 -> Aug

9 -> Sep

please help me

regards,

Re: make number to month name

Sokkorn — Tue, 14 Aug 2012 11:38:50 GMT

Hi MT,

Did you try this threads yet?

http://community.qlik.com/message/224231

http://community.qlik.com/thread/49830

Regards,

Sokkorn

Re: make number to month name

jonathandienst — Tue, 14 Aug 2012 11:43:24 GMT

Or (assuming MonthNum contains a number such as 8 for Aug

Month(MakeDate(2000, MonthNum, 1)) As Month

Regards

Jonathan

Re: make number to month name

jagannalla — Tue, 14 Aug 2012 11:47:38 GMT

Try this

FOR i=1 to 12

LOAD Month(MakeDate(Year(Today()),$(i),1)) as Month AutoGenerate(1);

FOR i=1 to 31

LOAD $(i) as Day AutoGenerate(1);

You can also concatenate the Month or Day field with your original table month & day fileds. By using Concatenate(Table1) Load ...

Cheers!

Jagan

Re: make number to month name

Wed, 14 Aug 2013 14:56:05 GMT

In your QV script, you can set your Month Names like this...

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

based on which, you can call them in your script below as ... Month(xyz) as "Month Name"

Re: make number to month name

Fri, 30 May 2014 07:28:46 GMT

Month

(MakeDate(year(Year,MonthNo))

Re: make number to month name

its_anandrjs — Fri, 30 May 2014 08:04:22 GMT

In your fact table or where you have field MonthNum use Mapping table and map the Monthname in the table See the load script

MapTable:

Mapping LOAD * INLINE [

MonthNum, MonthName

1, Jan

2, Feb

3, Mar

4, Apr

5, May

6, Jun

7, Jul

8, Aug

9, Sep

10, Oct

11, Nov

12, Dec

];

FactTable:

LOAD *, ApplyMap('MapTable',MonthNum) as MonthName Inline [

MonthNum

];

FactTable:

LOAD

*, ApplyMap('MapTable',MonthNum) as MonName

From Location;

Re: make number to month name

jagan — Fri, 30 May 2014 08:29:44 GMT

Hi,

Try like this

LOAD

Pick(MonthNumber, 'Jan', 'Feb', 'Mar', 'Apr', 'May','Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec') AS MonthName

From DataSource;

Regards,

Jagan.

Re: make number to month name

its_anandrjs — Fri, 30 May 2014 11:03:48 GMT

After load a table as mapping table then if you have problem to get the correct monthname then try to load your map table differently see the load script

MapTable:
Mapping LOAD
RowNo() as MonthNum,
Month(AddMonths((Today()),RowNo()+7)) as MonName
AutoGenerate 12;


FactTable:
LOAD *, ApplyMap('MapTable',MonthNum) as MonthName
Inline [
MonthNum
1
2
3
4
5
6
7
8
9
10
11
12
];

Regards

Anand

Re: make number to month name

preminqlik — Fri, 30 May 2014 11:13:16 GMT

hi try this

Load *,

month(Date#(field,'M')) as Monthname

from path;

Re: make number to month name

Sun, 21 Sep 2014 22:38:47 GMT

Thank you Jonathan. This works seems to work perfectly and simplest without need to use ApplyMaps or any loops. Would mark as correct!

Re: make number to month name

iskezhanov — Mon, 28 Dec 2020 04:00:56 GMT

date(MakeDate(2000, Your_Month_Number_field,1),'MMMM')

Re: make number to month name

mehranbi — Mon, 05 Sep 2022 07:33:08 GMT

Try this:

=Month( MakeDate(1, YourMonthNumber, 1) )