7 Replies Latest reply: Feb 26, 2015 3:36 AM by Geert Loeffen RSS

    Coloring another field based on If(IsNull()

    Geert Loeffen

      Hello Qlik Community,

       

      So what i want to do is based on a null value in field1, apply a grey color on field2, when said IF does not apply keep the color white.

       

      Is this possible in any way?

       

      I know you can apply a color to field1 but have not found a way to apply the color to another field when the if statement is met.

       

      I came up with this so far:

      =If(IsNull([Field1]), ([Field2], Red()), White())

       

      Thanks in advance.

       

      G.