Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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)