Sum orders delay

captain89 — Mon, 03 Oct 2016 09:59:02 GMT

Hi,

in my qlik app I'm trying to calculate the orders delay.

I've many types of order... some of these stays open until they're completely processed and they often are linked to many shipments.

So i made my data model by loading the shipments file with the required delivery date by the client and then i concatenated the residual orders file. When an order isn't processed I assume Ship Date=today().

Is there a way to sum the order delay when i collapse the pivot (in this case 7+4+1=12)?.

When the real "ship date" is lower then "ship no delay date" I consider a negative delay.

i try this but it doesn't work:

interval(sum([Ship Date]-if([Order Date]>=[Ship no Delay Date], [Order Date], [Ship no Delay Date])))

Thanks

Re: Sum orders delay

sunny_talwar — Mon, 03 Oct 2016 17:31:40 GMT

Is this expression working without collapsing? If it is, then may be you just need to aggregate function around to get it to work.

Interval(Sum(Aggr(Sum([Ship Date]-If([Order Date] >= [Ship no Delay Date], [Order Date], [Ship no Delay Date])), <YourChartDimensionsHere>)))

Make sure to replace this -> <YourChartDimensionsHere> with your the dimensions you are using in the chart separated by commas

topic Sum orders delay in QlikView

Sum orders delay

Re: Sum orders delay