2 Replies Latest reply: Nov 14, 2014 1:52 PM by Jose Wirtz Branched from an earlier discussion. RSS

    Table appearance - conditional styling colomns

      Hello Mike, if I have a dimension, can I do something similar as in a measure with Background or Text color expression?

        • Re: Table appearance - conditional styling colomns
          Michael Tarallo

          Hello Jose - yes - if you mean - conditional styling? - Where the background cell color or text color changes based on a value size?

           

          In your table element - you must aggregate your measure and in the property panel under columns for that measure you have the ability to change the colors for the text and background.

           

           

          See this help topic here for more information on coloring by expresison.

           

          Here is an example:

           

          if(

          sum([Nums]) > 9000, 'green', if(sum([Nums]) > 8800, yellow(), RGB(255,0,0)

          ))

           

          I also include 3 ways on how you can reference a color in the expression.

           

          Attached is a sample too a the bottom of this post.

           

          Just copy to C:\Users\<user profile>\Documents\Qlik\Sense\Apps (if using Qlik Sense Desktop) and press F5 to refresh the Desktop Hub.

           

          Please mark the appropriate replies as helpful / correct so our team and other members know that your question(s) has been answered to your satisfaction.

           

           

          Regards,

           

          Mike