Case statement in Qlikview

[#1]

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.

[bbi_mba_76 · Accepted solution]

Hi,

you could use the match function:

if(match(t_accrual_month_end.CATEGORY,'4','9','16','21','22')>0, 'Y', 'N')

[#3]

Thank you.