Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

livio218526
Contributor

Nested IF with AND operator in Qlik Sense

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

1 Solution

Accepted Solutions

Re: Nested IF with AND operator in Qlik Sense

You may miss understanding the IF condition

If([City Code]> 10 and [City Code] <20, 'A', If([City Code] >= 20 and [City Code] < 40, 'B', 'C'))

Explanation - If [City Code] arbitrary between 10 and 20 then it returns only A and [City Code] arbitrary between 20 and 40 then it returns only B. That means, If [City Code] < 10 and [City Code] >40 it returns C only. The same way your functionality works

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

36 Replies
Partner
Partner

Re: Nested IF with AND operator in Qlik Sense

Share full expression..

Re: Nested IF with AND operator in Qlik Sense

Try to create like below

If(Age>100 and Age<20, 'A', If(Age>=20 and Age<40, 'B'))

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
MVP
MVP

Re: Nested IF with AND operator in Qlik Sense

Remove last comma or put a else value, like:

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

OR

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



madhumitha
Contributor

Re: Nested IF with AND operator in Qlik Sense

HI,

You seem to have forgotten the default value.

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

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

Filling up the ??? will help you. else remove the comma after B.

Hope this helps

livio218526
Contributor

Re: Nested IF with AND operator in Qlik Sense

Hi,

i have try to create another calculated field like this:

If(City Code> 100 and City Code <20, 'A', If(City Code >= 20 and City Code < 40, 'B'))

But Qlik show me the same error

livio218526
Contributor

Re: Nested IF with AND operator in Qlik Sense

If(City Code> 100 and City Code <20, 'A', If(City Code >= 20 and City Code < 40, 'B'))

prma7799
Honored Contributor III

Re: Nested IF with AND operator in Qlik Sense

Just for reference ...

if([Sale>=10 and Sale <=20   ,Green(),

if(Sale >20 ,Blue(),

if(Sale >0 and Sale <10 ,Black(),

rgb(255,0,0))) )

livio218526
Contributor

Re: Nested IF with AND operator in Qlik Sense

No, qlik show me the same error....

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))) )

livio218526
Contributor

Re: Nested IF with AND operator in Qlik Sense

No, nothing. Qlik show me the same error