33 Replies Latest reply: Nov 16, 2017 4:44 AM by Livio Sebastiano Colombo 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,))

       

       

      Thanks,

      Livio