Show month number as month name

[guyvermeiren]

Hello,

In my data I have a field "Period" that gives the month number ( 1 to 12). In my table I would like to show this as the Month Name (January, February, ...). Can anyone tell me what Function I can use ?

Thanks already,

Guy

[hector]

Hi, check this post

http://community.qlik.com/forums/t/39425.aspx

Rgds

[#3]

Hi Guyvermeiren,

Its easy to use the inline i.e

Load * inline [

Period,Month

1,Jan

2,Feb

];

You can continue the same for remaining No till 12 ..

The Second solution is rename the period as month and set Month Names as 'Jan','Feb' etc .

Regards,

Chakravarthy.