This content has been marked as final. Show 2 replies
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