topic Re: Select greater than field selected in ListBox in QlikView

Select greater than field selected in ListBox

Anonymous — Thu, 02 Feb 2017 12:21:35 GMT

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

swuehl — Thu, 02 Feb 2017 12:25:12 GMT

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)

Anonymous — Thu, 02 Feb 2017 12:43:27 GMT

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

swuehl — Thu, 02 Feb 2017 12:54:16 GMT

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.

Anonymous — Thu, 02 Feb 2017 14:53:35 GMT

Yep Managed to Work Thanks Stefan