topic Re: IsNull function in QlikView

IsNull function

qlikviewwizard — Sun, 12 Jul 2015 08:57:34 GMT

Hi All,

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

Re: IsNull function

swuehl — Sun, 12 Jul 2015 09:01:22 GMT

=IsNull( 1 )

will return 0 (FALSE)

=IsNull( 1/0 )

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

Re: IsNull function

ashfaq_haseeb — Sun, 12 Jul 2015 09:02:30 GMT

Hi,

Check this

NULL handling in QlikView

Regard

ASHFAQ

Re: IsNull function

jagan — Mon, 13 Jul 2015 02:48:37 GMT

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.

Re: IsNull function

SatyaPaleti — Mon, 13 Jul 2015 07:07:49 GMT

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