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

    Comparing Data in a Straight table

    Jacodpl

      Hi All,

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

      Dimentions:

      Code, Description,InvNumber,DeliveryNote

      Expressions:

      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.

      Thanks,