ListBox with Not-Selection

[#1]

Hello,

i`ve searched the internet but didn´t found any suitable.

Let´s say i have a Listbox with some ids

id
1
2
3
4
5
...

What i´m trying to achieve is, when i select ids from this listbox the ids i´ve selected should be excluded from the measurements.

Like a Selection but here in Reverse. The values that are selected shall be excluded not included.

Is this possible?

Thank you

Steve

[Gysbert_Wassenaar · Accepted solution]

Just make your selection in the listbox, then right click the listbox and choose Select Excluded.

Or add a Select Excluded action to the OnSelect field trigger of the id field. You can find this trigger on the Triggers tab of the Document Properties window. Use id as field for the Select Excluded action.

[maxgro]

you can also type the excluded

[petter]

The forced exclusion could be a way to go for you - but it requires that you put the list box in and-mode:

Forced Exclusion

Forced exclusion (sometimes referred to as NOT-selection) is closely related to the AND-selection. The forced exclusion makes it possible to explicitly exclude a field value, which means that the solutions found by QlikView may not be associated with the excluded value.

The forced exclusion is made by clicking a cell and keeping the mouse button pressed until the cell turns red. Ctrl-clicking in this manner is equivalent to an exclusion that is an additional requirement to the previous selections/ exclusions. The forced exclusion can only be made on a field that is in AND-mode.

Search in QlikView Help or in the Reference Manual about and-mode and forced exclusion...

[buzzy996]

try tis,

right click on ur list box-- clikc on "select exclued"

[hugmarcel]

both "select excluded" and "NOT selection" do not include NULL values.

So the combination of "select something" and "select excluded" may not result in 100% coverage, as NULL values get lost.

Marcel