Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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