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