Sql logic in Qlik

[AjjuSid]

Hi All, 

Can you please help me with the SQL logic below, I am trying to migrate App based on SQL to Qlik. 

If ( ([abc Description] = 'A', 'B', 'C', 'D'),

(IF[Re Type]='Ind')
THEN ('Re')

ELSE IF([Re Type] in ('Loan'))
THEN ('Demo')

ELSE IF([Re Type] in ('Comp Purchase', 'Comp Purchase via Finance Company'))
THEN ('Corporate'))

ELSE ('Other')

Else [abc Description])

What would be the equivalent qlik script for the above part. 

Thanks.

[vinieme12 · Accepted solution]

If( wildmatch( [abc Description], 'A', 'B', 'C', 'D')

,Pick(Wildmatch ([Re Type],'Ind','Loan','Comp Purchase', 'Comp Purchase via Finance Company')+1,'Other','Re','Demo','Corporate','Corporate'),[abc Description])

[AjjuSid]

Thank you for your help.