Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
luiscla_icr
Contributor
Contributor

Working with Dates in Different Tables

249/5000

Hi guys
I'd like some help. I have two tables. Orders table and delivery table.
The order table has the date field of the order and the delivery table has delivery date.
How to filter all orders and deliveries from February / 2018?

4 Replies
JustinDallas
Specialist III
Specialist III

We need to know the structure of your data.  If there is no link between Orders and Deliveries (unlikely), then you can have a simple MasterCalendar and filter with that.

If your data has a link between Orders and Deliveries, then I guess you would have to concatenate the tables, and the then use the relevant date to link to your master calendar.

Personally,  I've never been able to solve this problem elegantly, because there isn't a reason to assume that the Order-Delivery link is 1:1.

h_prakash
Creator II
Creator II

Order_Delivery_Table:

Load 'Order' as Flag,

         Order Date as "Common Date"

Resident Order Table;

Concatenate (Order_Delivery_Table)

Load 'Delivery' as Flag,

         Delivery Date as "Common Table"

Resident Delivery Table;

Use the Common Date Field  as a filter where you can find Order and Delivery details with respect to date.

isingh30
Specialist
Specialist

Please share your data or app.

Thanks.

Digvijay_Singh

May be this, if your data fields are of date type -

Sum({<OrderDate={">=$(=MakeDate(2018,02,01))"},DeliveryDate={">=$(=MakeDate(2018,02,01))"}>}Value)