1 Reply Latest reply: Jan 11, 2018 12:40 PM by Oleg Troyansky RSS

    Background color expression not working correctly

    Andrew Moberg

      Hello

       

      I have an expression that is supposed to color code values as green that are greater than 70% however it is color coding values green that are less than 70%. Below is a screen shot of the expression and the output. The total at the top is 63.9% which is less than 70%; why is it green?

       

      Untitled picture.png

        • Re: Background color expression not working correctly
          Oleg Troyansky

          Hi Andrew,

           

          your color expression can only be valid at the detailed level, not at the total level. At the total level, the field [Day Utilization" may return multiple results, which turns the value to NULL and the whole expression is invalid. In this case, I'm guessing, the background color of the first row is adopted for the total.

           

          I'd recommend to make your calculation valid at the total level and hopefully it resolve the issue.

           

          I'd also recommend to add the default color value that should be used if both conditions are false. Currently, it returns NULL as the default. It might also cause the same issue.

           

          cheers,

          Oleg Troyansky

          Upgrade your Qlik skills at the Masters Summit for Qlik - coming to Prague this April!