12 Replies Latest reply: Jan 31, 2016 9:06 PM by Sunny Talwar RSS

    Nested if for color expression

    Jasson Giannini

      Howdy, I am trying to make a conditional if statement for a color expression in qlik sense. It goes something like this:

       

      if((decile = '1' or decile = '2' or decile = '3' or decile = '4'), green(),

      if (decile = '5' or decile '6' or decile = '7')

      ,blue()

      if(decile = '8' or decile = '9' or decile = '10')

      ,red())

       

      but for some reason I am still getting an error on parenthesis, 'expecting a ')'. Any assistance?