topic ShipDate Vs DueDate in QlikView

ShipDate Vs DueDate

Wed, 02 Jul 2014 20:24:46 GMT

Hello Folks,

Your helps are always appreciated!

I need to count the number of products delivered

On-Time: Shipment Date – Due Date <= 0

Late: Shipment Date – Due Date > 0

I have used the below set analysis for delivery on time but it is not working as expected.

=count( {$< [ProductID] = {">=$(=Date(ShipDate))<=$(=Date(DueDate))"} >} [ProductID] )

Kindly let me know

Kiru

Re: ShipDate Vs DueDate

jerem1234 — Wed, 02 Jul 2014 20:29:41 GMT

Set Analysis is only calculated once per chart, and not for each row or for each record. Therefore you can't have the DueDate and Shipment Date change for each record in set analysis. Try an if statement like:

count(If(date(ShipDate)<=date(DueDate), [ProductID]))

and for Late:

count(If(date(DueDate)<date(ShipDate), [ProductID]))

You may want to add distinct in there as well.

Hope this helps!

Re: ShipDate Vs DueDate

hic — Wed, 02 Jul 2014 21:18:31 GMT

I would define a field in the script already:

ShipDate - DueDate as DelayInDays,

Then you can do whatever you want using this in Set Analysis

HIC