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

[Anil_Babu_Samineni]

That's impossible. Because, The functionality is same for Script / UI.

[prma7799]

What error you are getting ...

If possible please share error screen or sample app.

[prma7799]

or use [City Code]  instead of City Code

[livio218526]

Hi, I try but in the Data Manager Qlik show me that missing right parenthesis. I don't understand

[prma7799]

if(City Code>=10 and City Code <=20   ,Green(),

if(City Code >20 ,Blue(),

if(City Code >0 and City Code <10 ,Black(),

rgb(255,0,0))) )

this is work for me please share your sample file

[livio218526]

No, I see the same error again

[prma7799]

Please share sample file ...

[livio218526]

How i can share you the fiels?

[prma7799]

Please check this

Uploading a Sample

[livio218526]

Qlik send me this error if i try to upload the file:

You are not allowed to create or update this content

However i've a simple xls with a field "City Code", by using this i want to create a new field like "PROVA" with the script:

if ([City Code] > 10 AND [City Code] < 50, 'HELLO',

if([City Code] >= 50 AND [City Code] < 100, 'WORLD', 'OTHERS'))

prma7799‌