Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vidyasagar159
Creator II
Creator 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
Specialist II
Specialist II

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
Specialist II
Specialist II

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

c_deniziak
Partner - Contributor
Partner - Contributor

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
Creator II
Creator II
Author

Thanks, David.

dwforest
Specialist II
Specialist II

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