Help with pivot table

Wed, 28 Jan 2015 16:58:43 GMT

I trying to get how long it takes our warehouse to ship orders. I have the following expressions that work from an individual order perspective

NetWorkDays(CalendarAvailableShipDate,CalendarShipDate)-1 = Calculates the days is takes to ship

if(Column(2) >= 8,1,0) = Takes the above expression and let's me know if order take longer than 8 days then puts a 1

The above works for each order, but when I want to see it based on a Customer perspective, it falls apart.

How can I write the above so when I group the pivot table by customer it will then add up all the orders and then divide by how many were late (if(Column(2) >= 8,1,0))

Hope this makes sense

Re: Help with pivot table

Anonymous — Wed, 28 Jan 2015 18:20:03 GMT

I assume you calculate these expressions on the front end.

Each order has one ship date but each Customer has multiple, hence it "falls apart". You can make it much easier by calculating the days and the late flag in the script.

topic Re: Help with pivot table in QlikView

Help with pivot table

Re: Help with pivot table