Canonical & Master Calendar

[RobinTMavhu]

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.

[rafaelencinas · Accepted solution]

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.

[marksouzacosta]

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