topic Re: IF Condition with a list in QlikView

IF Condition with a list

gfisch13 — Tue, 09 Nov 2021 16:52:15 GMT

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

Or — Tue, 09 Nov 2021 17:40:12 GMT

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

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

AshutoshBhumkar — Tue, 09 Nov 2021 17:44:11 GMT

Hello,

Maybe something like below.

Function is correct but some syntax error.

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

Thanks,

Ashutosh