Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
hi
have you try
=If(isnull(column(1)),
RGB(255,0,0),
RGB(0,128,0))
Thanks!!! That worked!!!!