topic Select greater then listbox values, based on other listbox selection in QlikView

Select greater then listbox values, based on other listbox selection

Fri, 25 May 2012 08:14:09 GMT

Hi, can anyone help me with the following?
I have two listboxes both containing a list of ordered values.
Say:

Listbox1 values "10, 15, 20, 25, 30, 35, 40"
Listbox2 values " 9, 15, 18, 19, 21, 25, 50"

Functionality needed: when listbox1 value is selected, then all values of listbox2 GREATER THEN listbox1 value should be selected.
Example:

Select listbox1 value = 15, then listbox2 should select: 18, 19, 21, 25, 50

Select listbox1 value = 20, then listbox2 should select: 21, 25, 50

Appreciate any help.

Regards Coen

Re: Select greater then listbox values, based on other listbox selection

swuehl — Fri, 25 May 2012 08:54:47 GMT

I think you can do this with trigger actions (you have to replace Field1 and Field2 with your field names, of course):

Open Settings->document properties->triggers

In field event trigger section, select your Field1 (Listbox1 values) and add actions for OnSelect.

Add 1 action of type selection - clear field and enter the Field2 name in to right upper field (just the field name)

Then create a second action of type selection - select in field

Field is again Field2

Search string (copy literally the exact same characters):

='=Field2>=Field1'

Hope this helps,

Stefan

Re: Select greater then listbox values, based on other listbox selection

Fri, 25 May 2012 09:44:36 GMT

Thank you for answering. Unfortunately your answer is not completely functional.
Selecting Field1 from low to higher values works ok, but after selecting in Field1 a smaller value than selected before does not work. This doesn't change anything. See attached qlikview file.

Btw: Action type "Clear field" is not available, so I choose : "Clear other fields"

QV-version: 10.00-SR4i

Any ideas?
Regards Coen

Re: Select greater then listbox values, based on other listbox selection

swuehl — Fri, 25 May 2012 09:54:36 GMT

Yes,

Clear Field is a new action in QV11 (well I remember an easter egg enabling Clear Field in Qv10, but let's not build on that).

Clear Other field will not work here.

But you can use selection - select in field as first action on field value2 and with a search string that will never match.

See attached.

Select greater then listbox values, based on other listbox selection

Fri, 25 May 2012 10:17:31 GMT

Thank you for your help.
Works great 🙂