Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
captain89
Creator
Creator

Sum orders delay

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().

qlik-r.jpg

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

1 Reply
sunny_talwar

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