Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
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)