Calculating Sum while excluding and including conditions

[#1]

I'm attempting to sum a value while conditionally excluding and including specific rows based on specific conditions.  I generated the following expression using the set analysis wizard for QlikView:

=Sum({$<Exchange-={'$(=OTC)','$(=NULL)','$(=PNK)'},[TR Adjusted Derivative Type]={'$(=Non-Derivative)'},[Trade to be Excluded?]={'$(=N)'}>}[TR Notional Value])

There are no values returned.  Something may be wrong with the syntax, but am unable to determine the problem.  Any feedback would be helpful.

[sunny_talwar · Accepted solution]

May be this:

=Sum({$<Exchange -= {'OTC','NULL','PNK'}, [TR Adjusted Derivative Type] = {'Non-Derivative'}, [Trade to be Excluded?] = {'N'}>}[TR Notional Value])

[petter]

Non-Derivative   should probably  be  [Non-Derivative]    ?

Are OTC, NULL PNK .... etc variables?  If they are you will not need to use an equal sign...

[#4]

Sunni,

That worked.  Thank you for your help.

Jeff

[sunny_talwar]

No problem. Glad I proved helpful.

Best,

Sunny