Getting Outstanding Order using Chart Table

[#1]

Hi, 

I have two tables: 

Table 1: Ordered Received

Order ID

Order Date

Order Item

Table 2: Order Dispatch

Order ID

Dispatch Date

Dispatch Item (Same as Order Item)

I need to do prepare a qlikview report to  show Outstanding Order that has not been dispatched.

Kindly advised how should I prepare my table, do I use Concatenate or left Join.  And when I used Chart Table, how do I get a list of all Order that has not been dispatched?

It seems quite straight forward, but I just could not get the Outstanding Order list right.

Thanks,

David

[sunny_talwar · Accepted solution]

May be this:

Count({<[Order ID] = e({<[Dispatch Date] = {'*?'}>})>}[Order ID])

This assumes that Dispatch date will be null when the order has not been dispatched yet.

[#3]

Work like a charm, sunny!! Brilliant!! Thank you so much!!

[sunny_talwar]

Awesome

I am glad it worked the way you wanted. Would you be able to close this thread by marking my answer as the correct answer.

Thanks,

Sunny