Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ramyasaiqv
Creator II
Creator II

Is there a better way to write this in Qlik script

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

1 Solution

Accepted Solutions
jheasley
Luminary Alumni
Luminary Alumni

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

View solution in original post

2 Replies
shivanandk
Partner - Creator II
Partner - Creator II

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

jheasley
Luminary Alumni
Luminary Alumni

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