7 Replies Latest reply: Feb 3, 2015 4:44 PM by William Wagner RSS

    Multiple If/than color expressions

      Hello,

       

      I am stuggling to find the correct syntax to create a 3 (or 4) color expression in QlikSense.  I am successful in Red / Green but when I attempt to create a 3rd variable or 4th, it falls apart.

       

      Field NameSum([ISSUES P1-Critical]

       

      Success with 2 Color Expression:  If (Sum([ISSUES P1-Critical])>10, lightred(),lightgreen())

       

      Fail with 3 Color Expression:  Try #1

       

      This equation fails, the error in expression states: ')' expected


      if (Sum ( [ISSUES P1-Critical] ) <10, lightgreen(), if( Sum ( [ISSUES P1-Critical])=>10 and Sum ( [ISSUES P1-Critical])<=50,Yellow(), lightRed() ) )

       

      If Sum of Issues is greater/equal to than (=<) 50, Red

      If Sum of Issues is between 10 and 50 = Yellow

      If Sum of Issues is less than (>) 10, Green.

       

      Thank you