topic Re: Sum: All but in QlikView

Sum: All but

Wed, 25 Jun 2014 09:18:40 GMT

Hi,

I've got some syntax problems when Im trying to sum all cleints but one (Client A), no matter the current selections.

Right now my expression looks like this:

Sum( {<~Client = {“*Client A*”}>} [Settlement amount] )

Sample attached.

Any ideas?

Kind Regards,

Olle

veidlburkhard — Wed, 25 Jun 2014 09:23:41 GMT

Hi Olle,

use this expression: sum( {<Client = {'Client A'}>} [Settlement amount] )

This will work...

Burkhard

ashfaq_haseeb — Wed, 25 Jun 2014 09:26:35 GMT

Hi,

Try below

To Show all except A

====================

sum( {<Client -= {'Client A'}>} [Settlement amount] )

To show only A

===========

sum( {<Client = {'Client A'}>} [Settlement amount] )

Regards

ASHFAQ

Wed, 25 Jun 2014 09:32:55 GMT

Thanks Ashfaq!