2 Replies Latest reply: Apr 14, 2016 1:42 PM by Sangram Reddy RSS

    Color in an Expression

    David Young

      I have attached my first application in QlikSense.  I am trying to apply conditional formatting on the expression of Work Days Open.  I have tried everything and it does not seem to be working.  I need some help.  Here is what I have:


      if([Work Days Open] >'10',Red(),White())


      I want the background of [Work Days Open] to be Red if the value is greater than 10 otherwise White.


      Let me know if there are any questions.



        • Re: Color in an Expression
          bruno bertels

          Hi David


          replace your color expression by this one in the color by expression panel menu


          your expression

          //if([Work Days Open] >'10',Red(),Green())



          if(sum(If([NewStatus] = 'Open',(If([Work Days Open]<30,1,0)),0))>'10',lightRed(),Green())


          if fact i took your mesure to evaluate the result > 10 in an if statement


          you may have this

          (then just adapt the color by expression mesure in all your mesure 30-60 , 60-90 etc


          hope it helps



          • Re: Color in an Expression
            Sangram Reddy

            Hi David,


            Try this was your expression:


            if([Work Days Open] > 10, red(),white())