Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can I write this case statement in qlikview.
case when t_accrual_month_end.CATEGORY not in ('4','9','16','21','22') then 'N'
else 'Y' end as MISC_FEE_RECURR_FLG,
Thank you very much.
Hi,
you could use the match function:
if(match(t_accrual_month_end.CATEGORY,'4','9','16','21','22')>0, 'Y', 'N')
Hi,
you could use the match function:
if(match(t_accrual_month_end.CATEGORY,'4','9','16','21','22')>0, 'Y', 'N')
Thank you.