Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

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

1 Reply
Highlighted
Not applicable

Pivot Table expression

Hi,
try expression

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

Alex