Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikviewwizard
Master II
Master II

IsNull function

Hi All,

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

1 Solution

Accepted Solutions
swuehl
MVP
MVP

=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
swuehl
MVP
MVP

=IsNull( 1 )

will return 0 (FALSE)

=IsNull( 1/0 )

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

ashfaq_haseeb
Champion III
Champion III

Hi,

Check this

NULL handling in QlikView

Regard

ASHFAQ

jagan
Luminary Alumni
Luminary Alumni

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.

SatyaPaleti
Creator III
Creator III

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