Case formula

[RKULKARNI4]

Hello Team,

I need to apply below mentioned formula  :

case ( Concat(Field1, Field2,Field3))

when 'C0 ' then 'ABC' when 'C01' then 'ABC'

when 'C1 ' then 'PR' when 'C1L' then 'PR' when 'C1A' then 'PRA'
when 'C2 ' then 'PR' when 'C2L' then 'PR' when 'C2A' then 'PRA' ELSE 'XYZ END

Please advise the formula in qliksense .

Thanks in advance

RK

[Taoufiq_Zarra]

@RKULKARNI4  Maye be this ?

	pick(
		RangeSum(Match(Field1&Field2&Field3,'C0','C01','C1','C1L','C1A','C2','C2L','C2A'),1),
		'XYZ','ABC','PR','PR','PR','PR','PR','PR','PR'
		) as NewField

output :