Nested IF with AND operator in Qlik Sense

[livio218526]

Hi everyone,

i have a problem when i try to create a new calculated field by using a Nested IF.

For example I have a Field Age and I want create a new Field (Color) with 'A' if Age > 10 and < 20, 'B' if Age >=20 and < 40 and so on...

I try to create this function but Qlik show me this error: missing right parenthesis:

if(Age > 10 and Age < 20,A,

7	if(Age >= 20 and Age < 40,B,))

Thanks,

Livio

[prma7799]

Your expression seems to be ok but without sample file how can I explain to or please  share excel file atleast.

[livio218526]

[prma7799]

Please share data don't attach screen shot..

[livio218526]

I can't share, qlik community send me that i'm not authorized for to do this operation.

[Anonymous]

This worked!! thanks

[chaudharybilal]

Hi

We are facing this same issue, did you get the solution to this ? I don't understand the difference in your script & the one in "Correct Answer".

[chaudharybilal]

We've found a solution: So using the same example If([City Code]> 10 and [City Code] <20, 'A', If([City Code] >= 20 and [City Code] < 40, 'B', 'C'))

We changed it to If([City Code]< 10,'C', if([City Code] <20, 'A', If([City Code]< 40, 'B', 'C')))

This will give you the same result.