topic Show only certain listbox values in QlikView

Show only certain listbox values

Wed, 15 Feb 2012 22:02:31 GMT

If I have a listbox with 10 values and I only want to show 6 of them that are handpicked. How should I do that?

Show only certain listbox values

swuehl — Wed, 15 Feb 2012 23:06:42 GMT

On general tab of your list box properties, select <expression> from the field list and enter:

=if(match(FIELD,'A','B','C','D','E','F'), FIELD)

where FIELD is your field name and A, B, C... are your handpicked values.

Hope this helps,

Stefan

Show only certain listbox values

Thu, 16 Feb 2012 00:19:35 GMT

That worked. Can I make one of them defaulted?

Show only certain listbox values

swuehl — Thu, 16 Feb 2012 08:48:51 GMT

You mean a default selection?

You can select your value, then select 'set clear state' from the selections menu or maybe create a trigger with action select in field (e.g. on open document event) to achieve something like this.

Re: Show only certain listbox values

Wed, 07 Aug 2013 11:09:28 GMT

HI,

If you want to select one particular value always.

Try this,

1. Select one value in the listbox

2. Go to the properties

3. Enable the option 'Always One Selected Value'

4. Apply and then OK.

I welcome all your feedback.