Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to use master calender in data modelling

Hi

How to use master calender in Qlikview

3 Replies
tresesco
MVP
MVP

Check this blog post: the-master-calendar

MK_QSL
MVP
MVP

Master Calendar is used for the Date Fields... The purpose is to fill the gapes where there are no data and transactions for any particular date...

The base is Minimum Date and Maximum Date of your data model... By using the Loop, we can have All Dates from Minimum Date to Maximum Date...

Now using these dates, we can have Week, WeekDays, Month, Year, Quarter, MonthYear, YearMonth etc as a separate calendar table which is associated with the main/fact table with the Date field.. (same name)...

Hope this will make clear idea on using Master Calendar... You can also use the link provided by tresesco..

Not applicable
Author