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: 
drohm002
Creator II
Creator II

Multi-box question

I have a multi-box using the field name "Event".  There are 20 values that can be displayed when you click the drop down arrow on the multibox.  I don't want to show all 20 values, I only want to show the values that say "Bad", "Good", and "Average".....how do I accomplish this?

1 Solution

Accepted Solutions
vishsaggi
Champion III
Champion III

Write an expression for your Event like in your multibox you have few buttons to add fields and remove fields. There is another button that says expression, click on it and use like below

= IF(Match(Event, 'Good','Bad','Average'), Event)

View solution in original post

1 Reply
vishsaggi
Champion III
Champion III

Write an expression for your Event like in your multibox you have few buttons to add fields and remove fields. There is another button that says expression, click on it and use like below

= IF(Match(Event, 'Good','Bad','Average'), Event)