Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Limiting values in a listbox object

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

3 Replies
alexandros17
Partner - Champion III
Partner - Champion III

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
Specialist III
Specialist III

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)

Not applicable
Author

maybe hide excluded on the properties of your listbox