Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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