Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Select greater then listbox values, based on other listbox selection

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

1 Solution

Accepted Solutions
MVP
MVP

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

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.

4 Replies
MVP
MVP

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

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

Not applicable

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

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

MVP
MVP

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

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.

Not applicable

Select greater then listbox values, based on other listbox selection

Thank you for your help.
Works great :-)

Community Browser