1 Reply Latest reply: Sep 7, 2018 3:14 AM by Priyal Paithankar RSS

    Color formula with %'s

    Ken Harry

      Hello Qlik friends,

       

      I am trying to write a color expression formula within a pivot table, saying (in plain terms) if column 2 is greater or less than 10% of column 1, then color it red. Otherwise, color it gray.

       

      I am familiar with Qlik formulas and color formulas, just need a little bit of guidance!

       

      Thanks!

      Ken