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 help

I have a field, "Patient_Type" that I want to put into my multi box.  The values inside this field are 1, 2, 3.  When a user clicks the drop down of "Patient Type" in the multi box, I want it to display "ER", "ED", "OR" instead of the actual values of 1,2,3....is this possible?  How can I assign "ER" to 1, etc.

1 Solution

Accepted Solutions
sunny_talwar

May be use an expression like this:

Pick(Patient_Type, 'ER', 'ED', 'OR')

View solution in original post

2 Replies
sunny_talwar

May be use an expression like this:

Pick(Patient_Type, 'ER', 'ED', 'OR')

drohm002
Contributor II
Contributor II
Author

thanks!