topic Re: Count if Order sum of cases shipped = sum of cases on order in QlikView

Count if Order sum of cases shipped = sum of cases on order

djbloiss — Mon, 13 Aug 2018 14:44:17 GMT

I need to create an expression that counts any perfect orders, any orders that are not short shipped.

This is the expression I am trying:

=Count({$<[Order Number]={"=Sum({$<SO_Closed={1}>} [SO Order Quantity])-Sum({$<SO_Closed={1}>} [Actual Quantity])>0"} [Order Number])

Sum({$<SO_Closed={1}>} [SO Order Quantity]) gives the cases on an order

Sum({$<SO_Closed={1}>} [Actual Quantity]) gives the cases that shipped

This is giving me an 'Error in set modifier expression' error.

All the fields are in the same table in Qlikview.

What am I missing?

vishsaggi — Mon, 13 Aug 2018 14:54:24 GMT

can you try this?

=Count(Aggr(IF(Sum({$<SO_Closed={1} >} [SO Order Quantity])-Sum({$<SO_Closed={1}>} [Actual Quantity]) > 0, [Order Number]), [Order Number]))

djbloiss — Mon, 13 Aug 2018 15:03:50 GMT

It is not giving me an error but I need to check if the numbers are accurate; thank you