Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
drohm002
Contributor II
Contributor 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)