topic Re: OR operator issue in QlikView

OR operator issue

sifatnabil — Wed, 15 Apr 2015 03:42:40 GMT

Hi all,

In script I have this statement:

if((match([Primary Currency],'CNH') or match([Secondary Currency],'CNH')),'Americas'

Even though the field "Secondary Currency" has a value CNH, this statement is not returning Americas. Why is this?

Anonymous — Wed, 15 Apr 2015 03:54:10 GMT

Hi,

If you have used the same statement as shown above, then your if statement is not closed properly. It should be

if((match([Primary Currency],'CNH') or match([Secondary Currency],'CNH'),'Americas')

sifatnabil — Wed, 15 Apr 2015 03:57:11 GMT

Thanks greeshma.kalathingal‌ , actually it is closed properly, I just showed you a part of my script. The part which is causing issues is this part:

if((match([Primary Currency],'CNH') or match([Secondary Currency],'CNH'))

robert_mika — Wed, 15 Apr 2015 04:35:32 GMT

Works for me

Can you post your full expression?

Did you try Wildmatch?

Anonymous — Wed, 15 Apr 2015 04:36:07 GMT

Could you share a sample file?

tamilarasu — Wed, 15 Apr 2015 04:47:07 GMT

Hi,

Try this,

IF(match([Primary Currency],'CNH') or match([Secondary Currency],'CNH'),'America')

Instead of yours.

America should be mentioned inside the bracket, so that if statement will show as America. You have wrongly typed outside of the if statement.

if((match([Primary Currency],'CNH') or match([Secondary Currency],'CNH')),'Americas'

See below attached example.

Anonymous — Wed, 15 Apr 2015 05:33:04 GMT

you can also try

if((match([Primary Currency],'CNH','Americas' if (match([Secondary Currency],'CNH')),'Americas')

anbu1984 — Wed, 15 Apr 2015 06:33:07 GMT

Check if spaces are present in fields [Primary Currency] or [Secondary Currency]

Also check if case mentioned in if statement matches with data present in the fields

PrashantSangle — Wed, 15 Apr 2015 06:46:41 GMT

Hi,

Few suggestion if you want case sensitive search go with Match()

if non case sensitive search go with Wildmatch

if there is spaces in it use wild character * or trim for removing before or after spaces.

Otherwise your expression is fine for me.

Regards