Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

luiscla_icr
New 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
drillnaut
Valued Contributor

Re: Working with Dates in Different Tables

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
Contributor

Re: Working with Dates in Different Tables

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
Contributor III

Re: Working with Dates in Different Tables

Please share your data or app.

Thanks.

Digvijay_Singh
Honored Contributor III

Re: Working with Dates in Different Tables

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

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