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

[djbloiss]

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]

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]

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