topic Re: Select all fields except one using searchs in QlikView

Select all fields except one using searchs

polisetti — Wed, 13 Aug 2014 14:05:08 GMT

I have a listbox having values: A,B,C,D,E etc

now in the search option can I search values as "All values excpet C". Basically client wants to select all values except one value. Is it possible.

Regards

Re: Select all fields except one using searchs

flipside — Wed, 13 Aug 2014 14:14:29 GMT

Easiest way is to select the value you don't want, then Select Excluded (via right click) to "reverse" the selection.

Re: Select all fields except one using searchs

sudeepkm — Wed, 13 Aug 2014 14:14:46 GMT

you can create another field based on your existing field (say FeildName is your existing field) in your load Script which will have logic like below.

if(FieldName='C','NA','All') as FieldSelect

Then you can use this new field FieldSelect in the Search Object. So that when Clients will select All then it will select all except C.

Re: Select all fields except one using searchs

marcus_sommer — Wed, 13 Aug 2014 14:15:39 GMT

Listbox search operator for "unequal"

Re: Select all fields except one using searchs

Wed, 13 Aug 2014 14:18:33 GMT

Hello,

Have you tried with the sign "-" before the value you want to exclude ?

For example, -C to select all values except C.

Regards,

Nicolas