Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
swuehl
MVP
MVP

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.

View solution in original post

4 Replies
swuehl
MVP
MVP

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
Author

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

swuehl
MVP
MVP

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
Author

Thank you for your help.
Works great 🙂