Limiting values in a listbox object

[#1]

Can somebody please advise me how I can limit members of a field that are visible in a listbox object. The data model includes many business units but I want to restrict those available in my list box to only a few, and I'll also want to limit expressions in other objects to include just specific business units.

Thank you

[alexandros17]

If your field is for example the division (Ex. from 20 to 100 step 10) and I want to see only division from 10 to 50 then in your listbox use the expression (at the end of field's list) and write your condition

Ex. If(Division <=50, division, null())

let mne know

[simondachstr]

Ideally, you should be doing that in the script/data model, but you can also add a calculated field in a listbox e.g.

=if(match(FIELD,'Key1','Key2' etc.), FIELD)

[#4]

maybe hide excluded on the properties of your listbox