Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Master II
Master II

IsNull function

Hi All,

Could you please give examples IsNull function. Thanks in advance.

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: IsNull function

=IsNull( 1 )

will return 0 (FALSE)

=IsNull( 1/0 )

will return -1 (TRUE), due to division by zero

View solution in original post

4 Replies
Highlighted
MVP
MVP

Re: IsNull function

=IsNull( 1 )

will return 0 (FALSE)

=IsNull( 1/0 )

will return -1 (TRUE), due to division by zero

View solution in original post

Highlighted

Re: IsNull function

Hi,

Check this

NULL handling in QlikView

Regard

ASHFAQ

Highlighted
MVP & Luminary
MVP & Luminary

Re: IsNull function

Hi,

IsNull() returns whether the given value is Null or not.  If the given value is Null it returns -1 otherwise 0.

-1 True, 0 for false.

Example:

IsNull(Null()) - Here Null() will return Null, so IsNull() returns -1 (True)

IsNull('SomeValue') - Here the value given is not a null so it returns 0 (False)

Hope this helps you.

Regards,

Jagan.

Highlighted
Creator III
Creator III

Re: IsNull function

Hi,

Isnull explain's wheather valuee is available or not

for example you are having

CustDetails:

Load * inline

[

CustomerrId,Age

1,20

2,35

,40

4,45

];

Create a Table Box with selecting CustDetails file

You will get a table box

Capture.JPG

if you do isnull(CustomerrId)

Then click on 1 you will get 0 as output because there is a valuee for Customerrid. if you click on empty value you will get -1 as output because there is no valuee for Customerrid.

Hope you understand

Thank you,

Satya paleti