topic Re: Canonical & Master Calendar in App Development

Canonical & Master Calendar

RobinTMavhu — Tue, 17 Jun 2025 06:50:56 GMT

I have tried but seems my Master calendar just wont work for my 2 variables i.e. Purchases and Usage. I have attached the application it would appear my graphs are showing incorrect calculations. I would appreciate someone who can fix and share an updated file.

Re: Canonical & Master Calendar

rafaelencinas — Tue, 17 Jun 2025 10:51:54 GMT

Hi @RobinTMavhu ,

In your case you have to make some changes in your model :

If you want to compare "Usage with Inventories" , one of this Tables must be connected directly with Mastercalendar,

In your model actualy, when you filter a date, filter all possible materials, no matter the date of usage or inventory, because the key is "Material".

Solution 1:

- Create a Linked Table with Dates and Materials creating a single key to link Usage and Inventoryes

Solution 2

- Concatenate usage and Inventory, creating commom fields to filter your data correctly.

Bye.

Re: Canonical & Master Calendar

marksouzacosta — Tue, 17 Jun 2025 14:10:11 GMT

Hi @RobinTMavhu,

There are two great articles that may help you to figure that out:

Calendars - Qlik Community - 1496392

Canonical Date - Qlik Community - 1463578

Both from our master @hic.

Regards,

Mark Costa