topic Re: NOT selection in AND-mode field in QlikView

NOT selection in AND-mode field

Wed, 01 Oct 2014 15:26:49 GMT

Assume you have a AND-mode listbox with values A,B,C,D

With a ACTION (behind a button) we want to make an automatic selection in this listbox :

We create the button and select the properties
in the ACTIONS tab we add the action -> SELECT IN FIELD
FIELD = the AND-mode listbox

So far so good, but then we have to fill in the SEARCH STRING.

If we want to make the selection A AND B, then our search string is : (A|B)
But what is the search string if we want to select A AND NOT B????

Re: NOT selection in AND-mode field

vgutkovsky — Wed, 01 Oct 2014 16:23:26 GMT

Sven, take a look at an alternate method of doing AND/NOT selections, which I discuss in the last comment to this post: http://community.qlik.com/thread/62060.

Vlad

Re: NOT selection in AND-mode field

Thu, 02 Oct 2014 08:07:54 GMT

Hi Vlad

I already checed out that post and gave me good insight in another problem

But here i really need to automate the selection i make in a Listbox and unfortunatly it's an AND-mode list box where we need to make NOT selections

Re: NOT selection in AND-mode field

Andrea_Ghirardello — Thu, 02 Oct 2014 08:41:21 GMT

Try to use regular expressions:

How to use regular expressions

In order to exclude some values (say NOT USA), use:

^((?!USA).)*$

Re: NOT selection in AND-mode field

Thu, 02 Oct 2014 11:14:14 GMT

I am not trying to exclude some values

i am trying to make a NOT selection in an AND-mode box (see attachment)

Re: NOT selection in AND-mode field

vgutkovsky — Thu, 02 Oct 2014 15:18:01 GMT

Sven, there are 2 list boxes in my solution: AND and NOT. Since they're separate, all you have to do is trigger a selection in the NOT list box.

Vlad

Re: NOT selection in AND-mode field

hugmarcel — Wed, 15 Jul 2015 11:52:54 GMT

it is not possible to set the NOT-state via Action button.

You have to use the SetAnalysis-Way, or do it manually in the listbox.

Marcel