topic Re: Master Calendar/Canonical Calendar in App Development

Master Calendar/Canonical Calendar

ManuelLindekeit — Fri, 26 Jun 2020 13:43:38 GMT

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

Re: Master Calendar/Canonical Calendar

dplr-rn — Fri, 26 Jun 2020 14:08:35 GMT

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