10 Replies Latest reply: Dec 4, 2009 9:52 AM by Jacodpl RSS

    Comparing Data in a Straight table


      Hi All,

      I am very new to Qlikview so please point me in the right direction. I have a straight table:


      Code, Description,InvNumber,DeliveryNote


      Items = Sum(Sales Order Qty) - Sum(Credit Note Qty)

      Will it be possible to only subtract the credit note qty if the InvNumber = DeliveryNote in the selection, else ignore credit note qty. I've attached a print screen.