Button search select field action: how to exclude one value

[#1]

hi all,

I know how to include a value for filtering using a button action 'Select in Field' but I don't know how to exclude a value (e.g. <>'myvalue' in SQL). Any ideas?

Mat

[#2]

I am trying to figure out how to do this as well. Were you able to get this to work?

[Miguel_Angel_Baeyens]

Hi,

Just use two actions, one Search in Field, and the second Search Excluded in that same field.

Hope that helps.

[Oleg_Troyansky]

Or, as an alternative, just format a search condition - "<>myValue" in the Select Action

[#5]

I have a button set up that currently does this...

(5*|6*|2*|*118429308*)

It takes all data in my field that starts with 5, 6, 2, and is 118429308.

I have another button that does this...

(1*|0*|8*|7*)

It takes all data in my field that starts with 1, 0, 8, and 7. However, I want it to exclude the number 118429308 even though it starts with a 1.

How do I do this?

[giakoum]

see an extraordinary solution here :

http://community.qlik.com/message/229000#229000