topic Month from a string in QlikView

Month from a string

Thu, 08 Dec 2011 09:57:53 GMT

Hi Everyone,

I have a string field in the following format:

January

February

March

...

etc

I want to tell QV that it's months... Any idea how I do that?

Thanks

Gareth

Month from a string

Thu, 08 Dec 2011 10:08:36 GMT

Hi,

The first three characters are the monthname's in QV.

So, do something like this:

num(left(month,3),'00') and then you have the monthnum's in QV.

Succes,

Halmar

Re: Month from a string

sridhar240784 — Thu, 08 Dec 2011 10:11:05 GMT

Hi,

You use inline wizard to do this.

Load * Inline [

Month,Monthno

January,1

February,2

March,4

....

...

];

You can use this Month field to map to your transaction field.

if you have Date field with format 10-January-2011.

You can extract the month using below code.

=Num(Month(Date(Date#(Date,'DD-MMMM-YYYY'))),'00')

Hope this helps.

-Sridhar

Re: Month from a string

Sokkorn — Thu, 08 Dec 2011 11:18:22 GMT

Hi Gareth,

Can you attached your sample data source more than two field (include month field)? I want to know that the field that store your month is a DateTime or String field.

Regards,

Sokkorn Cheav

Month from a string

Thu, 08 Dec 2011 13:23:52 GMT

I managed to do it with the following code:

MONTH(date#(MONTH, 'MMMM')) AS MONTH

MMMM tells QV that the string is a long month name format. The original field is definitely a string, not a date/time.