Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Show only certain listbox values

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?

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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

View solution in original post

4 Replies
swuehl
MVP
MVP

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

View solution in original post

Not applicable
Author

That worked.  Can I make one of them defaulted?

swuehl
MVP
MVP

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.

Not applicable
Author

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.