Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

heosupplink
New Contributor

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

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.

1 Solution

Accepted Solutions
lironbaram
Honored Contributor II

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

hi

have you try

=If(isnull(column(1)),

RGB(255,0,0),

RGB(0,128,0))

2 Replies
lironbaram
Honored Contributor II

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

hi

have you try

=If(isnull(column(1)),

RGB(255,0,0),

RGB(0,128,0))

heosupplink
New Contributor

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

Thanks!!! That worked!!!!

Community Browser