Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Easy Question on Expression?

Hi all-

New to Qlik Sense!  I'm working with an Access Database and am trying to figure out how to code the following...

Access Output

Title: Final Disposition

Options are 1,2,3,

Those options stand for something, i.e. 1 =  resume, 2 = destroy/cancel

Where/how do I code so that I can make 1 = "resume"?

1 Solution

Accepted Solutions
sunny_talwar

You can do like this in the script

Pick(Output, 'resume', 'destroy/cancel', '...') as Output

or on the front end

=Pick(Output, 'resume', 'destroy/cancel', '...')

View solution in original post

1 Reply
sunny_talwar

You can do like this in the script

Pick(Output, 'resume', 'destroy/cancel', '...') as Output

or on the front end

=Pick(Output, 'resume', 'destroy/cancel', '...')