Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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
Highlighted
Master III
Master III

Re: Master Calendar

Hi,

  Max(OrderDate) As MaxDate

instead of

  Max(OrderDate) As Maxdate

Regards,

Antonio

Highlighted
Creator
Creator

Re: Master Calendar

Thank you!