topic IF statement ?= CASE statement(from script) in QlikView

IF statement ?= CASE statement(from script)

ivan_will — Wed, 17 Mar 2010 10:34:17 GMT

Could you tell me how can I make if statement(in qlikview, not in the script!) to be the same like this case statement in the script:

( CASE

WHEN A= 5 THEN 1

WHEN A = 4 THEN 2

ELSE 3

END ) FLAG

blaise — Wed, 17 Mar 2010 11:00:00 GMT

if(A=5,1,if(A=4,2,3)) as FLAG

oleg_orlov — Fri, 31 May 2013 07:14:51 GMT

WildMatch (A, '5', '4', '*')

or more flexible solution:

Pick (WildMatch (A, '5', '4', '*'),

'One',

'Two',

'Three'

)