topic Re: explain difference between Null and IsNull ? in QlikView

explain difference between Null and IsNull ?

Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

tell me with simple example for null and isnull functions.how to handle the null valules.

Thanks

trdandamudi — Wed, 28 Sep 2016 15:48:04 GMT

If you do not have a value in a field it is called a 'Null'

Example :

Country =

You use IsNull to check if a field is null.

Example:

IsNull(Country)

Hope this helps...

Wed, 28 Sep 2016 15:57:26 GMT

The function Null() returns a Null value, for example:

State = Null(); (function)

will evaluate to State = Null (value).

The function isNull() returns a value depending on whether the value evaluated is indeed a null value, for example:

State = Null (value)

isNull(State) is true (or 1) because State is Null.

I hope this isn't too confusing...

Let me know,

Arthur

marcus_sommer — Thu, 29 Sep 2016 07:08:36 GMT

- Marcus

avinashelite — Thu, 29 Sep 2016 08:35:43 GMT

Null( )

Returns a real NULL value means it will return a null data itself you consider it as not data

IsNull(expr )

Returns -1 (true) if expr returns NULL, otherwise 0 (false).

I.e it will return a value 1 if the value is null or if it has data then it returns 0