Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikviewforum
Creator II
Creator II

How to use Master Calendar with two or more different dates from different table

I have OrderDate in Order table and DispatchDate in Dispatch table and etc... How can make use of Master Calendar in his scenario. Please let me know your idea.

Labels (2)
1 Solution
2 Replies
rahulpawarb
Specialist III
Specialist III

May be this:

Order Table has OrderDate & OrderId and Dispatch Table has DispatchDate & DispatchId fields then create a bridge table; this will be linked to Master calendar and Order as well as Dispatch tables.

DateBridge:
LOAD DISTINCT
OrderId,
OrderDate AS Date,
'Order' AS DateType
Resident Order
Where ISNULL(OrderDate) = 0;
Concatenate
LOAD DISTINCT
DispatchId,
DispatchDate AS Date,
'Dispatch' AS DateType
Resident Dispatch
Where ISNULL(DispatchDate) = 0;

 

Use below sort of set analysis expression:

Count({<DateType={'Order'}, Date={">=$(=MonthStart(AddMonths(Max(Date), -11))) <=$(=Max(Date))"}>}OrderId)

Count({<DateType={'Dispatch'}, Date={">=$(=MonthStart(AddMonths(Max(Date), -11))) <=$(=Max(Date))"}>}DispatchId)