IF statement ?= CASE statement(from script)

[ivan_will]

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]

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

[oleg_orlov · Accepted solution]

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

or more flexible solution:

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

      'One',

      'Two',

      'Three'

)