Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

explain difference between Null and IsNull ?

Hi all,

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

Thanks

4 Replies
trdandamudi
Master II
Master II

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...

Not applicable

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
MVP & Luminary
MVP & Luminary

Take a look here: NULL handling in QlikView

- Marcus

avinashelite

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