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.

       

      David

        • 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())

           

          mine

          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

           

          Bruno

          • Re: Color in an Expression
            Sangram Reddy

            Hi David,

             

            Try this was your expression:

             

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

             

            Thanks,

            Sangram