36 Replies Latest reply: Sep 13, 2018 10:00 AM by Bilal Chaudhary RSS

    Nested IF with AND operator in Qlik Sense

    Livio Sebastiano Colombo

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