topic Re: Null() function in QlikView

Null() function

qlikviewwizard — Sun, 12 Jul 2015 09:00:54 GMT

Hi All,

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

swuehl — Sun, 12 Jul 2015 09:03:25 GMT

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 — Sun, 12 Jul 2015 09:11:19 GMT

Hi swuehl

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

swuehl — Sun, 12 Jul 2015 09:26:57 GMT

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:

jagan — Mon, 13 Jul 2015 02:45:59 GMT

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.