6 Replies Latest reply: Jan 29, 2018 8:38 PM by Buck Master RSS

    How do you count specific Colored results in a table

    Buck Master

      Trying to write a KPI that shows the number of rows returned where the background color was changed to Red based on a condition.

      This is the FX:

       

      If ( TOTAL_TAX > Avg(TOTAL <[Category Type]> TOTAL_TAX) , red() , green() )

       

      Running Qlik Sense November Release desktop

       

      Thanks in advance