Discussion board where members can get started with QlikView.
Could you please give examples IsNull function. Thanks in advance.
=IsNull( 1 )
will return 0 (FALSE)
=IsNull( 1/0 )
will return -1 (TRUE), due to division by zero
View solution in original post
NULL handling in QlikView
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.
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.
Isnull explain's wheather valuee is available or not
for example you are having
Load * inline
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