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

[heosupplink]

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.

[lironbaram · Accepted solution]

hi

have you try

=If(isnull(column(1)),

RGB(255,0,0),

RGB(0,128,0))

[heosupplink]

Thanks!!! That worked!!!!