2 Replies Latest reply: Jan 7, 2018 6:21 PM by Hector Espinosa RSS

    Can't find the way to use Null in an if expression

    Hector Espinosa

      Hi:

       

      I have an expresión which result may be null, and the resulta is expressed in Qlik Sense as "-".

       

      When i try to make a new expression in which i have an if conditional I can't seem to use the null expresión:

       

      Example

       

      Result column 1 = "-".

       

      =If(column(1)=null(),

      RGB(255,0,0),

      RGB(0,128,0))

       

      How can I make it work.