Multiple dates - Canonical Calendar, Master Calendar, & Fiscal Year (544)

EMaebe — Thu, 07 Oct 2021 21:00:31 GMT

Good afternoon,

I'm creating an app using Salesforce data as well as actual sales data. Currently, I'm only working on the Salesforce data model. In my opportunity data, I have a 'created date', a 'status last modified date', a 'last modified date', and a 'close date'. Eventually, I will be pulling in sales data to validate closed opportunities, so I will have an 'invoice date' (and potentially I will be bringing in an 'order date' and a 'shipped date' depending on the metrics / calculations).

In researching how to handle the calendar for these data sets, I believe I need a canonical calendar with multiple master calendars. However, I would like for my calendar to be a fiscal calendar (we use a 5-4-4 fiscal calendar that starts in October. With the caveat that Q1 of 2021 was a 5-4-5). Am I correct in thinking I need a canonical calendar with multiple master calendars? Is it possible for the master calendar to be a fiscal calendar only? Or do I need to create a master calendar with fiscal calendar option (https://community.qlik.com/t5/Qlik-Sense-Documents/Master-Calendar-Script-with-Optional-Fiscal-Year/ta-p/1692173) and do this for each date field? If so, where do I add the 'Canonical_Date' in the script to this to link to the DateBridge? Finally, how do I handle that my fiscal calendar is a 5-4-4, starts in October, and Q1 2021 was a 5-4-5?

topic Multiple dates - Canonical Calendar, Master Calendar, & Fiscal Year (544) in App Development

Multiple dates - Canonical Calendar, Master Calendar, & Fiscal Year (544)