Is there a better way to write this in Qlik script

[ramyasaiqv]

Hello Community,

I have  written a nested if function to achieve this but was wondering is a there a better way to write the same in qlik script using qlik functions? please give me your inputs.

if( Name='AK', 'Yes' ,

if( Name='KK', 'Yes' ,

if( Name='MK', 'Yes' ,

if( Name='TK', 'Yes' ,

if( Name='HK', 'Yes' ,

if( Name='BK', 'Yes' , 'No'))))) as Main

Thanks,

Ramya

[shivanandk]

If (match(Name,'AK','KK','MK','TK','HK','BK')>0,'Yes','No') as Main

[jheasley · Accepted solution]

If (match(Name,'AK','KK','MK','TK','HK','BK'),'YES','NO') as Main

OR

If (Not match(Name,'AK','KK','MK','TK','HK','BK'),'NO','YES') as Main