Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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'
Please see if this works
Pick(Match(Col1, 'N', 'O'), 'erreur', 'accepted') & If(not Match(Col1, 'N', 'O'), 'rejected')
Please see if this works
Pick(Match(Col1, 'N', 'O'), 'erreur', 'accepted') & If(not Match(Col1, 'N', 'O'), 'rejected')
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