master calender help

Thu, 08 May 2014 11:10:20 GMT

hey,

what is master calender and how to use it. Can you give me some scenario.

Re: master calender help

its_anandrjs — Thu, 08 May 2014 11:19:56 GMT

If you have a fact table or there is transaction dates or common dates which is running in the system and that is the main date then you have to connect this date to any master calendar like if you need date dimensions or field like

Month,Year,Week,Weekstart,Quarter and etc many more normally the tables not keept this fields then we use master calendar.

See the Master Calendar Script

=======================

Let varMinDate = Num(Makedate(2006,1,1));

Let varMaxDate = Num(Makedate(Year(today()),Month(today()),Day(today())));

Datefield:

LOAD

Date($(varMinDate)+IterNo()-1) AS CommonDatefield,

Year(date($(varMinDate)+IterNo()-1)) as Year,

Month(date($(varMinDate)+IterNo()-1)) as Month,

Day(date($(varMinDate)+IterNo()-1)) as Day,

Time(date($(varMinDate)+IterNo()-1)) as Time,

'Q' & Ceil(Month(date($(varMinDate)+IterNo()-1)) / 3) AS Quarter,

AUTOGENERATE (1)

WHILE $(varMinDate)+IterNo()-1<= $(varMaxDate);

In this CommonDateField is attached to the fact table date field.

Re: master calender help

Josh_Good — Thu, 08 May 2014 18:30:37 GMT

This video should help.

Re: Creating A Master Calendar

Re: master calender help

Joseph_Musekura — Thu, 08 May 2014 18:57:46 GMT

Hi,

Check the attached document. It explains how to.

topic Re: master calender help in QlikView

master calender help

Re: master calender help

Re: master calender help

Re: master calender help