topic Re: Getting Outstanding Order using Chart Table in QlikView

Getting Outstanding Order using Chart Table

Wed, 30 Sep 2015 08:43:48 GMT

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

Re: Getting Outstanding Order using Chart Table

sunny_talwar — Thu, 01 Oct 2015 20:00:12 GMT

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.

Re: Getting Outstanding Order using Chart Table

Wed, 07 Oct 2015 10:42:03 GMT

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

Re: Getting Outstanding Order using Chart Table

sunny_talwar — Wed, 07 Oct 2015 15:09:20 GMT

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