what is meant by master calender

[#1]

hai

[Anonymous]

It is a logical table often created in qlikview data model, containing dates in a variety of formats - date, month,quarter, year, week, etc.

[robert_mika]

Look here for more

Understanding the Master Calendar (video)

[MarcoWedel]

Hi,

another script that creates a calender table out of a previously loaded table containing the field "Date":

tabCalendar: 
LOAD *, 
    Day(Date) as Day, 
    WeekDay(Date) as WeekDay, 
    Week(Date) as Week, 
    WeekName(Date) as WeekName, 
    Month(Date) as Month, 
    MonthName(Date) as MonthName, 
    Dual('Q'&Ceil(Month(Date)/3),Ceil(Month(Date)/3)) as Quarter, 
    QuarterName(Date) as QuarterName, 
    Year(Date) as Year, 
    WeekYear(Date) as WeekYear;   
LOAD Date(MinDate+IterNo()-1) as Date 
While MinDate+IterNo()-1 <= MaxDate; 
LOAD Min(Date) as MinDate, 
     Max(Date) as MaxDate 
Resident tabSourceOfDate;

hope this helps

regards

Marco

[ToniKautto · Accepted solution]

Master Calendar is a quite frequent topic in the community. I would suggest that you use the search option and look at the previous blog posts, questions and documents. If these does not clear enough, then post a question to specify what part you are stuck on.

[Anonymous]

Have you ever searched in community before posting here ??