Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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