Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.