Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

mASTER cALENDAR

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

1 Reply
Not applicable
Author

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.