Discussion Board for collaboration on QlikView Layout & Visualizations.
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 :
So far so good, but then we have to fill in the SEARCH STRING.
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.
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
Try to use regular expressions:
How to use regular expressions
In order to exclude some values (say NOT USA), use:
I am not trying to exclude some values
i am trying to make a NOT selection in an AND-mode box (see attachment)
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.
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.