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: 
gfisch13
Creator II
Creator II

IF Condition with a list

Hi folks - I'm trying to crreate an filter box within my script and I keep getting "missing )" errors.

I'm selecting values from a field that are either Included or Excluded.  I just can't seem to get the syntax right.  Any help is appreciated.

Am I using the correct function with MATCH??

if(match(SCBCOUNTRY='AE','BH','QA'), 'Excluded', 'Included') as CountryInd,

 

Thanks, George

Labels (3)
2 Replies
Or
MVP
MVP

if(match(SCBCOUNTRY,'AE','BH','QA'), 'Excluded', 'Included') as CountryInd,

Wrong syntax for match. It doesn't take an equal sign.

AshutoshBhumkar
Partner - Specialist
Partner - Specialist

Hello,

Maybe something like below.

Function is correct but some syntax error.

if(match(SCBCOUNTRY , 'AE','BH','QA'), 'Excluded', 'Included') as CountryInd

 

Thanks,

Ashutosh