mASTER cALENDAR

Wed, 23 Jun 2010 09:58:47 GMT

DERS,

WHEN I APPLIED MASTER CALENDAR IN THE DEVELOPER 1 EXERCISE INSTEAD OF SHOWING ME FROM 2004 TO 2009 IT SHOWED ME ONLY 2OO8 AND 2009 I WANT TO KNOW DOES THE SCRIPTS IS TURE OR NOT AND WHY IT SHOW ME LIKE THIS

THIS FOR THE EXERCISE DEVELOPER 1

REGARDS

ABDALLA

mASTER cALENDAR

Wed, 23 Jun 2010 10:09:09 GMT

Hi!!

In master calendar I adapt some script. And in my QV file it's shows all year.

You can try :

MasterCalendar:
LOAD
OrderDate,
Week(OrderDate) AS Week,
Year(OrderDate) AS Year,
Month(OrderDate) AS Month,
Day(OrderDate) AS Day,
Weekday(OrderDate) AS WeekDay,
applymap('Quarters_Map', num(month(OrderDate)), null()) AS Quarter,
Date(monthstart(OrderDate), 'MMM-YYYY') AS MonthYear,
Week(OrderDate)&'-'&Year(OrderDate) AS WeekYear,
Year2Date(OrderDate, 0, 1, $(vToday))*-1 AS CurYTDFlag,
Year2Date(OrderDate,-1, 1, $(vToday))*-1 AS LastYTDFlag
RESIDENT Orders;

Another way, I think you need to create TempDate fields. And it's explain in another one document.

Hope this help.

topic mASTER cALENDAR in QlikView

mASTER cALENDAR

mASTER cALENDAR