Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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]))
It is not giving me an error but I need to check if the numbers are accurate; thank you