Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hello,
Try this
Sum( {$-<SaleType={'Pontoons'}>-<SaleType={'Engines'}> } SalesDollars)
Cheers,
JuanD
Hello,
Try this
Sum( {$-<SaleType={'Pontoons'}>-<SaleType={'Engines'}> } SalesDollars)
Cheers,
JuanD
Sum ({<SaleType-={'Pontoons','Engines'}>} SalesDollars)
Thanks - it worked - I don't have a clue why - but maybe I'll understand what all the symbols are for!
This one did not work - I tried that from Chapter 11 in the Qlikview 11 book