topic Re: Convert YYYYMMDD into Monthname in QlikView

Convert YYYYMMDD into Monthname

Wed, 17 Feb 2016 06:54:00 GMT

Hello All,

I need to convert 'YYYYMMDD' into monthname like 'Jan. , Feb. , etc....'

I manage to convert it into date using the below:

Date(alt(Date#(DATE, 'YYYYMMDD')), 'DD/MM/YYYY') as Date_Interview,

Any idea?

KR,

Hasvine

Re: Convert YYYYMMDD into Monthname

Chanty4u — Wed, 17 Feb 2016 06:57:45 GMT

Date(alt(Date#(DATE, 'YYYYMMDD')), 'MMM') as Date_Interview,

or u want only month name ? or with date format?

Re: Convert YYYYMMDD into Monthname

tresB — Wed, 17 Feb 2016 06:58:13 GMT

Month(Date#(DATE, 'YYYYMMDD')) as Month

Re: Convert YYYYMMDD into Monthname

MayilVahanan — Wed, 17 Feb 2016 06:58:32 GMT

Try like this

Load *, Month(Date_Interview) AS Month, Year(Date_Interview) AS Year;

Load *,

Date(Date#(DATE, 'YYYYMMDD'),'DD/MM/YYYY') AS Date_Interview

YourTableName;

Re: Convert YYYYMMDD into Monthname

Wed, 17 Feb 2016 07:00:47 GMT

I want the month name.

I managed to do the date.

Many Thanks,

Hasvine

Re: Convert YYYYMMDD into Monthname

Anonymous — Wed, 17 Feb 2016 07:04:03 GMT

just add Month() to your exprression like this?

month(Date(alt(Date#(DATE, 'YYYYMMDD')), 'DD/MM/YYYY')) as Date_Interview_Month,

Re: Convert YYYYMMDD into Monthname

jagan — Wed, 17 Feb 2016 07:08:30 GMT

HI,

Try like this

LOAD

Month(Date_Interview) AS Month_Interview;

LOAD

Month(Date#(DATE, 'YYYYMMDD'), 'DD/MM/YYYY') as Date_Interview

FROM DataSource;

Hope this helps you.

Regards,

Jagan.

Re: Convert YYYYMMDD into Monthname

Wed, 17 Feb 2016 07:14:16 GMT

Thanks.

It works.

Kind Regards,

Hasvine

Re: Convert YYYYMMDD into Monthname

tresB — Wed, 17 Feb 2016 07:16:36 GMT

Some of the functions here are unnecessary I see, the same could be got using a simpler expression I shared above.

Month(Date#(DATE, 'YYYYMMDD')) as Month

It's better to be better. Isn't it?

Re: Convert YYYYMMDD into Monthname

rajeshforqlikvi — Wed, 17 Feb 2016 07:20:55 GMT

=Date(Addmonths(today(),-1),'MMM')

Re: Convert YYYYMMDD into Monthname

sangeethag — Wed, 17 Feb 2016 07:20:59 GMT

Can you write your output expectation clearly?

For Month Name you just try this, use either in Script / expression

LOAD Date(MakeDate(left(Date,4),Mid(Date,5,2),Right(Date,2)),'YYYYMMDD') As Date,

Date(MakeDate(left(Date,4),Mid(Date,5,2),Right(Date,2)),'YYYYMMMDD') As DateMonthName,

Month(Date(MakeDate(left(Date,4),Mid(Date,5,2),Right(Date,2)),'YYYYMMMDD')) As MonthName

FROM

(ooxml, embedded labels, table is Sheet1);

Output will be:

Re: Convert YYYYMMDD into Monthname

Anonymous — Wed, 17 Feb 2016 07:21:01 GMT

Agreed, Same can be achieved by removing Date() & Alt() function from the above mentioned expression.

I thinks,she might be using Alt() functionality, then I just add month() to her expression. Else this would be working perfectly as well..

Month(Date#(DATE, 'YYYYMMDD')) as Month

Re: Convert YYYYMMDD into Monthname

rajeshforqlikvi — Wed, 17 Feb 2016 07:21:48 GMT

Hi You can use like this as below example:

=Date(Addmonths(today(),-1),'MMM')

Re: Convert YYYYMMDD into Monthname

Anonymous — Wed, 17 Feb 2016 07:31:03 GMT

month(DATE COLUMN) AS DATE _iNTERVIEW