Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
tell me with simple example for null and isnull functions.how to handle the null valules.
Thanks
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...
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
Take a look here: NULL handling in QlikView
- Marcus