Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Not applicable
Author

Hi,
try expression

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

Alex