topic Re: Limiting values in a listbox object in QlikView

Limiting values in a listbox object

Fri, 17 Oct 2014 13:02:42 GMT

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

Re: Limiting values in a listbox object

alexandros17 — Fri, 17 Oct 2014 13:07:13 GMT

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

Re: Limiting values in a listbox object

simondachstr — Fri, 17 Oct 2014 13:07:28 GMT

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)

Re: Limiting values in a listbox object

Sat, 18 Oct 2014 17:50:17 GMT

maybe hide excluded on the properties of your listbox