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