Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
If (match(Name,'AK','KK','MK','TK','HK','BK')>0,'Yes','No') as Main
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