topic Month Name in QlikView

Month Name

Wed, 28 Sep 2011 08:18:52 GMT

Hi!

in my excel file i've date in format yyyymmdd. I want to create the variable month with month name...

Now i use :

LOAD *,

MID([Date],5,2) AS Month

FROM

C:\Folder\DB.xlsx

(ooxml, embedded labels);

to catch the 2 numbers of month.

How can i conect the month name?

i use :

LOAD *,

Month( MID([Date],5,2)) AS Month

FROM

C:\Folder\DB.xlsx

(ooxml, embedded labels);

but all is consider as january...

Thank you

Marco

Month Name

Wed, 28 Sep 2011 08:29:25 GMT

Hi Marco,

QV will return the first 3 characters of a month, ex: Jan.

If you want to see the complete month name you can create an mapping table with 2 columns like Jan January and using the applymap function you can implement it.

Re: Month Name

Wed, 28 Sep 2011 08:33:16 GMT

Hi Marco,

i hope this helps you.

Stefano.

Month Name

Wed, 28 Sep 2011 08:34:09 GMT

hi Marco,

try this

load *,

month(date(Date,'YYYYMMDD')) as Month

from ...

hope this helps

Gilles

Month Name

Wed, 28 Sep 2011 08:39:43 GMT

Thank you!!!

Now it works!

Grazie Stefano!