Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
try expression
Sum({<OverviewInventoryTransHistory.TRANSACTION_CODE={'SCP'}>} COST)
Alex