Putting a NOT in a search string in a sheet action

[#1]

When a user switches to a certain sheet i want it to set the value of a cetain field to be everything but 1. So I need help figuring out what to put in the Search String box under the Actions window.

Thanks.

[#2 · Accepted solution]

='<>1'

I think the equals sign is the indicator that your are going to be using an expression or something other than a straight value. If you are using numerics, that should work fine, it may be a little tougher with strings.

EDIT: I think with strings, it may be best to do two actions. One to select the value you don't want and then a Select Excluded on the same field.

[#3]

Sorry forgot to mention that yes it is a string. You suggestion to set the field then exclude it works perfectly though. Thanks!!

[#4]

Hi NMiller,

I tried it for mayself with

='<> 40191'

in the search string. But it wasn't as expected:

I will use next time "Select Exclude" but anyway: What is wrong here?

Regards, Roland

[#5]

The <> sign do not work as NOT modifier. Qlikview considers t<> signas' less than' and greater than respectively. In effect , while using ='<> 40191' search string  we end up with all the values >40191. I couldn't find exclude clause with QLikview search string

[#6]

Hi Paulijn,

the question in this thread is about using triggers (actions) to preserve a selection when a user enters a new sheet.

In this case you can use: sheet props --> triggers --> add action "Select in Field".

Here the "<> 1" won''t work (as you described correctly). Now the workaround from NMiller is to choose a  "Select in Field" action with a "=1" as search mask and add a second action called "select excluded" to achieve the "<> 1".

RR