topic Re: ListBox with Not-Selection in QlikView

ListBox with Not-Selection

Wed, 06 May 2015 10:51:33 GMT

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

Re: ListBox with Not-Selection

Gysbert_Wassenaar — Wed, 06 May 2015 10:55:41 GMT

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.

Re: ListBox with Not-Selection

maxgro — Wed, 06 May 2015 10:59:20 GMT

you can also type the excluded

Re: ListBox with Not-Selection

petter — Wed, 06 May 2015 11:16:15 GMT

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...

Re: ListBox with Not-Selection

buzzy996 — Wed, 06 May 2015 11:19:28 GMT

try tis,

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

Re: ListBox with Not-Selection

hugmarcel — Mon, 29 Jun 2015 10:21:50 GMT

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