IsNull() function

[#1]

hi, can anybody tell me in simple words what is IsNull() and why and where is it used?

[Gabriel]

Hi,

Please read this blog post by HIC for better understanding of NULL

[Gysbert_Wassenaar]

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

What part(s) of this sentence don't you understand?

[ToniKautto]

Please remember to mark correct and helpful answers, to show your gratitude for the effort that has been put in to answering your questions. It will also indicate if you are happy with the replies or if you require more input.

[ashishpalkar]

Hi Gysbert

How can we use following in Qlik?

,ISNULL(I.instrumentcusip,ISNULL(I.instrumentsedol,ISNULL(I.instrumentisin,I.instrumentticker))) AS [SECURITY ID]

thanks

[Gysbert_Wassenaar]

You can use it as text to fill some space. Put '//' in front of it and it can be used as a comment.

Isnull takes only one argument. So it you try to use it with two arguments your script will throw an error.

If you have a question then creating a new discussion for it is a better idea than digging up a discussion that's been dead and buried for three years.

[jafari_ervin]

qlikview help is very useful.

https://help.qlik.com/en-US/sense/November2018/Subsystems/Hub/Content/Sense_Hub/Scripting/NULLFuncti...