topic Re: Retrieving Month and Year in QlikView

Retrieving Month and Year

Fri, 25 Apr 2014 06:57:59 GMT

I Have one Serial number Like 11061311012, the first six digits are date field. I am retrieving the those six digits means 110613 i.e date. I am using this field how can i retrieve the month and year like Jun-2013.

Re: Retrieving Month and Year

swuehl — Fri, 25 Apr 2014 07:00:50 GMT

Use

month(date#('110613','DDMMYY') )

resp. the year() function. (Edit: Or any other Date functions from the Help, like Monthname() )

Re: Retrieving Month and Year

MK_QSL — Fri, 25 Apr 2014 07:17:14 GMT

Use Below in your Script

Date(Date#(Left(11061311012,6),'DDMMYY')) as Date,

Month(Date#(Left(11061311012,6),'DDMMYY')) as Month,

Year(Date#(Left(11061311012,6),'DDMMYY')) as Year,

Date(Date#(Left(11061311012,6),'DDMMYY'),'MMMM-YYYY') as Month-Year

you can replace 11061311012 with your DateField

Hope this helps..

Re: Retrieving Month and Year

jagan — Fri, 25 Apr 2014 07:24:29 GMT

Hi Kiran,

Try like this

=Date(date#(Left('11061311012'),'DDMMYY'), 'MMM-YYYY' )

=Date(date#(Left(DimensionName),'DDMMYY'), 'MMM-YYYY' )

Regards,

Jagan.

Re: Retrieving Month and Year

its_anandrjs — Fri, 25 Apr 2014 07:50:11 GMT

You can write like

=Date(Date#(left(YourDateDimension,6),'DDMMYY'),'MMM-YYYY')

=MonthName(Date#(left(Date,6),'DDMMYY'))