Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
suepenick
Contributor

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
Highlighted
Not applicable

Re: Need Expression to exclude 2 types in sum If expression

Hello,

Try this

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

Cheers,

JuanD

View solution in original post

4 Replies
Highlighted
Not applicable

Re: Need Expression to exclude 2 types in sum If expression

Hello,

Try this

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

Cheers,

JuanD

View solution in original post

Highlighted
Not applicable

Re: Need Expression to exclude 2 types in sum If expression

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

Highlighted
suepenick
Contributor

Re: Need Expression to exclude 2 types in sum If expression

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

Highlighted
suepenick
Contributor

Re: Need Expression to exclude 2 types in sum If expression

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