topic Re: Master Calendar in QlikView

Master Calendar

Anonymous — Tue, 28 Oct 2014 12:33:08 GMT

Hi, can anyone tell me where and when master calendar is used? Also state its advantages.

Re: Master Calendar

ashfaq_haseeb — Tue, 28 Oct 2014 12:38:04 GMT

Hi,

Check this.

http://community.qlik.com/blogs/qlikviewdesignblog/2012/10/16/the-master-calendar

Regards

ASHFAQ

Re: Master Calendar

Tue, 28 Oct 2014 12:40:49 GMT

hi,

Creating A Master Calendar

Re: Master Calendar

jpenuliar — Tue, 28 Oct 2014 12:44:07 GMT

http://community.qlik.com/blogs/qlikviewdesignblog/2014/02/17/canonical-date

this one from Henric Cronstrom

Re: Master Calendar

its_anandrjs — Tue, 28 Oct 2014 13:07:24 GMT

Hi,

There is many reasons for this

1. You have Date field but rest of the date dimensions Year, Month, Quarter, YearStart, Day, Week etc are not available then you have to use the master calendar.

2. You have no proper Date formatted date field in the data model.

Example Code for the Master Calendar

LET vDateMin = Num(MakeDate(2014,04,05));

LET vDateMax = Floor(Today());

TempCalendar:

LOAD

date($(vDateMin)+IterNo()-1) AS Datefield,

date($(vDateMin)+IterNo()-1) AS TempDate

AUTOGENERATE (1)

WHILE $(vDateMin)+IterNo()-1<= $(vDateMax);

Calendar:

LOAD

Date(TempDate) AS ActionTime,

// Standard Date Objects

Day(TempDate) AS CalendarDayOfMonth,

WeekDay(TempDate) AS CalendarDayName,

Week(TempDate) AS CalendarWeekOfYear,

Month(TempDate) AS CalendarMonthName,

'Q' & Ceil(Month(TempDate)/3) AS CalendarQtr,

Year(TempDate) AS CalendarYr,

// Calendar Date Names

WeekName(TempDate) as CalendarWeekNumberAndYear,

MonthName(TempDate) as CalendarMonthAndYear,

QuarterName(TempDate) as CalendarQuarterMonthsAndYear

RESIDENT TempCalendar ORDER BY TempDate ASC;

DROP TABLE TempCalendar;

Regards

Anand