topic Date field converting in QlikView

Date field converting

Thu, 03 Feb 2011 13:46:18 GMT

Hi,

I have one date field, I would like convert it into Year;Qtr what formula do I need to use either in edit script or edit expression.

ex: 23-01-2009 need it like 2009;Q4

Can anyone guide me pls.

Thanks,

Date field converting

Thu, 03 Feb 2011 14:20:29 GMT

You can try this for year Year(DateField) as Year and that separates the year for you, and Quarter I am not sure, but will let you know if I have one.

Mama

Date field converting

Thu, 03 Feb 2011 14:28:30 GMT

Hello,

Calendar:
LOAD DISTINCT
OrderDate,
Year(OrderDate) as Year,
Month(OrderDate) as Month,
Date(Monthstart(OrderDate), 'MMM-YYYY') as YearMonth,
'Q' & Ceil(Month(OrderDate)/3) as Quarter,
Dual(Year(OrderDate) & '-Q' & Ceil(Month(OrderDate)/3), Year(OrderDate) & Ceil(Month(OrderDate)/3)) as YearQtr,
Week(OrderDate) as Week
RESIDENT OrderHeader;

I Found this above script in one of the Demo apps, please play around with this and you should be able to get what you want...

Mama