Need Expression to exclude 2 types in sum If expression

[suepenick]

I am trying to use an expression to sum sales for everyting except to types

Sum (if(SaleType <> 'Pontoons' or 'Engines', SalesDollars)

It's excluding the Pontoons but not the Engines

How do I write this expression to work properly

[#2 · Accepted solution]

Hello,

Try this

Sum( {$-<SaleType={'Pontoons'}>-<SaleType={'Engines'}> } SalesDollars)

Cheers,

JuanD

[#3]

Sum ({<SaleType-={'Pontoons','Engines'}>} SalesDollars)

[suepenick]

Thanks - it worked - I don't have a clue why - but maybe I'll understand what all the symbols are for!

[suepenick]

This one did not work - I tried that from Chapter 11 in the Qlikview 11 book