Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

vidyasagar159
Contributor II

Apply Map Function for Multiple columns

Hi,

Can someone please help me in creating an ApplyMap function and InLine table for the below case expression.

CASE 

When ([MRN_CTG_NM]~="Target") and ([IDX_FND_IN]=0) then "Plan Using RDFs"

When ([MRN_CTG_NM]~="Target") and ([IDX_FND_IN]=1) then "Plan Using RDFs"

ELSE

"Plans Without RDFs"

End

Thanks,

-Vidya

1 Solution

Accepted Solutions
dwforest
Valued Contributor

Re: Apply Map Function for Multiple columns

ApplyMap works strictly for translaltion of code to description, e.g. 1 = male, 2 = female.

If the translation is conditional on multiple fields it is done in the sql as shown or if statements in the LOAD

View solution in original post

4 Replies
dwforest
Valued Contributor

Re: Apply Map Function for Multiple columns

ApplyMap works strictly for translaltion of code to description, e.g. 1 = male, 2 = female.

If the translation is conditional on multiple fields it is done in the sql as shown or if statements in the LOAD

View solution in original post

Partner
Partner

Re: Apply Map Function for Multiple columns

Any reason that something like this wouldn't work? If((Match(Upper([MRN_CTG_NM]),'TARGET') and Match([IDX_FND_IN],0,1)), 'Plan Using RDFs','Plans Without RDFs')

vidyasagar159
Contributor II

Re: Apply Map Function for Multiple columns

Thanks, David.

Highlighted
dwforest
Valued Contributor

Re: Apply Map Function for Multiple columns

Should work in a LOAD statment or UI as a dimension / variable formula