1 Reply Latest reply: Aug 27, 2010 4:32 AM by Alessandro Neri RSS

    Pivot Table expression

      What I am looking for is an expression which calculates the SUM COST only for a field where the TRANSACTION_CODE = 'SCP'


      Here is what I have so far but it is not displaying what I am looking for


      Sum ({$<COST = [$(OverviewInventoryTransHistory.TRANSACTION_CODE = 'SCP'))}>}


      I am new to Qlikview and any help would be much appreciated