IsNull function

[qlikviewwizard]

Hi All,

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

[swuehl · Accepted solution]

=IsNull( 1 )

will return 0 (FALSE)

=IsNull( 1/0 )

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

[ashfaq_haseeb]

Hi,

Check this

NULL handling in QlikView

Regard

ASHFAQ

[jagan]

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]

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

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