Creating a Master Calendar for multiple time Dimensions

[Amit_B]

Hi everyone,

I have a data table with multiple time dimensions.
For the example, let's take 3 of them - OrderOpeningDate, ShippingDate, OrderClosingDate.
I will use all of them in the UI app.

In the UI sheet, I will use buttons to select one of the three dimensions I mentioned, and there are filter buttons for time dimensions like Year, Month and more.
So:
* If the user selects OrderOpeningDate field as the leading dimension, the time filters should be OrderOpeningYear and OrderOpeningMonth.
* If the user selects ShippingDate field as the leading dimension, the time filters should be ShippingYear and ShippingMonth.

Let's say there is a bar chart displaying order's quantities per month, and the user want to see data for the first quarter of 2024.
* If the user selects OrderOpeningDate field as the leading dimension, there are 30 orders on January, 26 orders in February and 33 orders in March.
* If the user selects ShippingDate field as the leading dimension, there are 27 orders on January, 34 orders in February and 18 orders in March.

In this case, I need to create a separate Master Calendar for each dimension, which is something I want to avoid. Additionally, I will need some actions when changing the leading dimension.
I want to create a single Master Calendar for all the 3 dimensions.

I would appreciate help on this topic.

[Kushal_Chawda · Accepted solution]

@Amit_B  see the below link. You can use DateFlag as a selection filter or filter in set analysis measure.

https://community.qlik.com/t5/App-Development/Create-a-common-Calendar/m-p/2064060#M700

[hic]

I think you should create a master calendar for each dimension. Take a look at the following post:
https://community.qlik.com/t5/Design/Canonical-Date/ba-p/1463578