Null() function

[qlikviewwizard]

Hi All,

Could you please give examples Null() function. Thanks in advance.

[swuehl]

Are you going through the list of all functions?

I would suggest having a look at the HELP, the reference manual or searching the forum...

=IsNull( NULL() )

will return -1 (TRUE)

[qlikviewwizard]

Hi swuehl

I read in help but unable to understand. Could you give some sample data example... Thank you.

[swuehl]

NULLs:
LOAD IsNull(F1) as IsF1Null, F1;
LOAD If(F1< 0.25, NULL(),F1) as F1;
LOAD RAND() as F1
AutoGenerate 20;

And you already got this link, I recommend to go through each reference document:

NULL handling in QlikView

[jagan · Accepted solution]

Hi,

Null() returns a Null value wherever it is used, it is mainly used to assign a Null() value to a field/variable or to a expression.

Suppose,

vNullValue = Null()

It will assign Null Value to the variable.

Regards,

Jagan.