Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

adil_hussain
Contributor II

Select greater than field selected in ListBox

Hi All

I currently have a List box with values

Example 1 2 3 4 5 6 7 8 9 10

I want, if someone selects 8 it selects 8 and greater than 8

If someone selects 1 it selects all available greater than and including 1

How is this possible?

Thanks

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: Select greater than field selected in ListBox

You can use an OnSelect field trigger action (from settings - document properties - trigger) with an

Selection - Select in field action on the same field and using a search expression like

='>=' & Max(FIELDNAME)

4 Replies
Highlighted
MVP
MVP

Re: Select greater than field selected in ListBox

You can use an OnSelect field trigger action (from settings - document properties - trigger) with an

Selection - Select in field action on the same field and using a search expression like

='>=' & Max(FIELDNAME)

adil_hussain
Contributor II

Re: Select greater than field selected in ListBox

This is great Stefan and works when a field name exists

I have a variable in my Dashboard to get date diff as below

Script:

SET MonthDiff = Num(((year($2) * 12) + month($2)) - (((year($1) * 12) + month($1))) + 1);

Listbox:

$(MonthDiff(Createdate, Today()-1))-1

At the moment i can select example 0 1 2 3


I thought it would work with this but it hasn't,Any ideas? Thanks

MVP
MVP

Re: Select greater than field selected in ListBox

If you select in this list box, you basically make a selection in field Createdate, right?

You could try to use this field as field in the action and modify the search appropriately.

adil_hussain
Contributor II

Re: Select greater than field selected in ListBox

Yep Managed to Work Thanks Stefan