Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
MVP
MVP

Re: Easy Question on Expression?

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', '...')

1 Reply
MVP
MVP

Re: Easy Question on Expression?

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', '...')