Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

Community Browser