topic Week-Year in Date format in QlikView

Week-Year in Date format

qw_jakub — Fri, 31 Jan 2014 08:35:05 GMT

Hello,

is there a way to format a date field as WeekNumber-Year (1-2013,2-2013, ..., 53-2013) similar to:

date(monthstart(TempDate), 'MMM-YYYY') as [Month-Year]

I can do it as

Week(TempDate) & '-' & Year(TempDate)

but this will not be understood as a date represantaion a will not sort accordingly.

Thanks for any suggestions!

tresB — Fri, 31 Jan 2014 08:40:00 GMT

Try weekname() function.

qw_jakub — Fri, 31 Jan 2014 08:49:32 GMT

Thanks,

this is simple and good sollution. Is there a way to reformat it from '2013/52' to: '52-2013' ?

jvishnuram — Fri, 31 Jan 2014 08:50:59 GMT

Hi Jakub,

Try this,

DATE:

Load Max(Date) as MAX_DATE,

Min(Date) as MIN_DATE

from Table_Name;

Let vMinDate = Peek('MIN_DATE',0,'DATE');

in the calendar use this.,

Num(Week($(vMinDate) + IterNo() - 1), '00')&'-'&Num(Year($(vMinDate) + IterNo() - 1)) as EXPEXTED

tresB — Fri, 31 Jan 2014 08:56:53 GMT

I guess there is no system date format for the same. You can consider (in the front end) changing the representation using string functions.