Master Calendar

lionking15 — Wed, 25 Nov 2020 16:16:04 GMT

In my data model i am having 4 table with date as field and all are different dates and if i want to link all those 4 table(2 dimension and 2 fact) with master calendar how to do??

Thanks!!

Re: Master Calendar

swuehl — Wed, 21 Sep 2016 06:03:17 GMT

Have a look at

Tutorial - Using Common Date Dimensions and Shared Calendars

Re: Master Calendar

Anil_Babu_Samineni — Wed, 21 Sep 2016 06:22:52 GMT

See If this helps

Calendar:

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,

'Q'&Ceil(Month(Date)/3) & '-' & Year(Date) as QuarterYear,

QuarterName(Date) as QuarterName,

Year(Date) as Year,

Day(Date) & '-' & Month(Date) as DayMonth,

'Week'&Ceil(Day(Date)/7) as WeekNum,

WeekYear(Date) as WeekYear;

LOAD Date(MinDate+IterNo()-1) as Date

While MinDate+IterNo()-1 <= MaxDate;

LOAD MakeDate(2014) as MinDate,

Today() as MaxDate

AutoGenerate 1;

topic Re: Master Calendar in QlikView

Master Calendar

Re: Master Calendar

Re: Master Calendar