Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Master Calendar

Why is the Master Calendar not working?

GetDateRange:

Load

  Min(OrderDate) As MinDate,

  Max(OrderDate) As Maxdate

Resident Facts;


Let vMinDate = Peek('MinDate', 0, 'GetDateRange');

Let vMaxDate = Peek('MaxDate', 0,'GetDateRange');

TempCalendar:

Load

  date($(vMinDate) + RowNo()) As TempDate

AutoGenerate $(vMaxDate) - $(vMinDate) + 1;

MasterCalendar:

Load

  TempDate        As OrderDate,

  Day(TempDate)   As Day,

  Year(TempDate)  As Year,

  Month(TempDate) As Month,

  Week(TempDate)  As Week,

  'Q' & Ceil(Month(TempDate)/3)   As Quarter,

  Date(MonthStart(TempDate), 'MMM-YYYY') As MonthYear

Resident TempCalendar

Order By TempDate Asc;

Drop Table GetDateRange;

Drop Table TempCalendar;

2 Replies
antoniotiman
Master III
Master III

Hi,

  Max(OrderDate) As MaxDate

instead of

  Max(OrderDate) As Maxdate

Regards,

Antonio

Anonymous
Not applicable
Author

Thank you!