Case based conditions from SQL to Qlik sense

[kaushi2020]

Below is a case statement written in SQL, looking forward for support to convert this to qlik sense expressions.

case
when cat_name like '%Auto%' then 'Auto'
when cat_name like 'Mot%' then 'Motor'
when cat_name like 'Tes%' then 'Testing'
when cat_name like 'Pen%' then 'Pending'
when cat_name like 'hold%' then 'On-Hold'
else 'Others'
end Category

thanks in advance.

[BrunPierre]

Hi, Like this.

Coalesce(If(WildMatch(cat_name,'*Auto*'),'Auto',
If(WildMatch(cat_name,'Mot*'),'Motor',
If(WildMatch(cat_name,'Tes*'),'Testing',
If(WildMatch(cat_name,'Pen*'),'Pending',
If(WildMatch(cat_name,'Hold*'),'On-Hold'))))),'Others') as Category