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

    Coloring another field based on If(IsNull()

      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.