3 Replies Latest reply: Dec 20, 2015 7:14 PM by Ignacio Garribia RSS

    How to calculate number of orders with errors in qlik sense

    Ignacio Garribia

      Hello Everyone! I need your help!

       

      I have to calculate the number of orders with errors. An error ocurrs when the quantity of Items ordered is different from the quantity of items shipped.

       

      I have the fields: Order ID, Shipment ID and Product ID

      and calculated measures:( in master items):

       

      Quantity of Items ordered( ((COUNT([ProductID]))/COUNT(DISTINCT(OrderID))

      Quantity of Items Shipped ((COUNT([ProductID]))/COUNT(DISTINCT(ShipmentID))

      Numbers of different Orders ( Count(Distinct(OrderID)

       

      How can I calculate the number different orders with errors?

      Thank you very much for your help.