Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ramyasaiqv
Contributor 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
Contributor

Re: Is there a better way to write this in Qlik script

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

2 Replies
Highlighted
shivanandk
Contributor II

Re: Is there a better way to write this in Qlik script

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

jheasley
Contributor

Re: Is there a better way to write this in Qlik script

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