topic Button search select field action: how to exclude one value in QlikView

Button search select field action: how to exclude one value

Wed, 03 Mar 2010 19:28:44 GMT

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

Button search select field action: how to exclude one value

Fri, 18 Mar 2011 17:41:14 GMT

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

Button search select field action: how to exclude one value

Miguel_Angel_Baeyens — Fri, 18 Mar 2011 17:56:13 GMT

Hi,

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

Hope that helps.

Button search select field action: how to exclude one value

Oleg_Troyansky — Fri, 18 Mar 2011 19:49:02 GMT

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

Re: Button search select field action: how to exclude one value

Fri, 15 Jun 2012 14:16:10 GMT

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?

Re: Button search select field action: how to exclude one value

giakoum — Fri, 15 Jun 2012 14:26:32 GMT

see an extraordinary solution here :

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