case when

[taz803]

i want to do this in qliksense but the  syntaxe is wrong : 

if(Col1 ='N') then  'erreur' ;

if(Col1 ='O') then   'accepted' ;

if other case then 'rejected'

[Chirantha · Accepted solution]

Please see if this works 

Pick(Match(Col1, 'N', 'O'), 'erreur', 'accepted') & If(not Match(Col1, 'N', 'O'), 'rejected')

[taz803]

Thank you it work  in the visualization mode , 

if i want to add in the sql  request: 

select type , 

Pick(Match(Col1, 'N', 'O'), 'erreur', 'accepted') & If(not Match(Col1, 'N', 'O'), 'rejected') as test_type

 FROM mytable 

==> this request don't work

[taz803]

Pick(Match(Col1, 'N', 'O'), 'erreur', 'accepted') & If(not Match(Col1, 'N', 'O'), 'rejected') as test_type