Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

what is meant by master calender

hai

1 Solution

Accepted Solutions
ToniKautto
Employee
Employee

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.

2015-06-04 09_26_55-what is meant by master calender _ Qlik Community.png

View solution in original post

5 Replies
mov
Employee
Employee

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

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
Employee
Employee

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.

2015-06-04 09_26_55-what is meant by master calender _ Qlik Community.png

balkumarchandel
Specialist II
Specialist II

Have you ever searched in community before posting here ??