Discussion board where members can get started with Qlik Sense.
Can someone please help me in creating an ApplyMap function and InLine table for the below case expression.
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"
"Plans Without RDFs"
Go to Solution.
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
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')
Should work in a LOAD statment or UI as a dimension / variable formula