If & and condition isnt working in the calculated field

[pal25]

Hi all,

I am finding error in this below formula. It says "Missing right parenthesis"

IF ([Country] = 'India' AND  Age < 5,'Yes',IF ([Country] <>'India' AND Age < 10,'Yes','No'))

Can someone help to identify the error. I am new to this tool and willing to learn

[micheledenardi]

This part of formula is correct, the error must be somewhere else

[pal25]

What should check ?

When i remove "AND" function (Age<5) , the formula works. But AND is required. 

Unable to figure out why the error coming

[micheledenardi]

Please share the qlik screenshot where you have this problem

[pal25]

Formula with updated variable names

[micheledenardi]

Seems the AND is not recognized as logical operator.

Which is the object you're writing this expression?

[pal25]

Yes looks like AND is not being recognized. Any workaround to that ?

Sorry, dint get your second question on "object". 

[qlikeers]

Maybe try something like this:

=If(Country = 'India',
if(Age < 5,'YES',

(If(not match([Country],'India'),
if(Age < 10,'YES','NO')))))

[pal25]

Thanks, unfortunately same issue with this one formula as well. 

I am new to qliksense and unable to figure the root cause 😞

[vinieme12]

Where exactly are you trying to add this expression?

Which object is this? expressions need to be added in the expression editor

can you post a full screenshot?