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: 
suepenick
Creator
Creator

Need Expression to exclude 2 types in sum If expression

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

1 Solution

Accepted Solutions
Not applicable

Hello,

Try this

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

Cheers,

JuanD

View solution in original post

4 Replies
Not applicable

Hello,

Try this

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

Cheers,

JuanD

Not applicable

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

suepenick
Creator
Creator
Author

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

suepenick
Creator
Creator
Author

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