Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
ManuelLindekeit
Contributor III
Contributor III

Master Calendar/Canonical Calendar

Hello, 

I'm looking for clarification on a calendar question that I have. 

I was looking at this blog post and working through it (thanks Analytics Hub for posting). I was able to use the test data and solve in an app bu creating a link table and 1 master calendar. 

But I confused because I recently studied HIC's post on canonical calendar. https://community.qlik.com/t5/Qlik-Design-Blog/Canonical-Date/ba-p/1463578

So I think with HIC's approach it would have been a link table, a canonical table, 2 master calendars, correct? 

Can anyone explain to me what the differences are in these approaches and when to use which? 

Thanks

1 Reply
dplr-rn
Partner - Master III
Partner - Master III

Canonical date is a way of expanding the use of Master calendar.

Specifically cases where there are multiple date that the users want to slice and dice their data on. but want a singular experience

so in HIC s example. end users wants to slice and dice on both Ordered date and shipped date. (eg User wants every order shipped or ordered in a month year). they way to achieve this is to create master calendars for order  and shipped date . then connect those using canonical calendar. 

So You use master calendar when there is 1 main date

and use canonical date when there is more than 1