topic Re: IsNull ? in QlikView

IsNull ?

Tue, 18 Mar 2014 09:16:21 GMT

IsNull([Start_Date])=0 means..

MK_QSL — Tue, 18 Mar 2014 09:18:31 GMT

It will check if Start_Date is Null...

its_anandrjs — Tue, 18 Mar 2014 09:19:20 GMT

Hi,

Isnull returns

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

Thanks & Regards

veidlburkhard — Tue, 18 Mar 2014 09:21:28 GMT

Hi Helen,

the QV help file sais: IsNull() Returns -1 (true) if expr returns NULL, otherwise 0 (false)

Hope this helps.

Burkhard

senpradip007 — Tue, 18 Mar 2014 09:27:39 GMT

IsNull(<YourField>) = 0 means when <YourField> contains not null value the function returns 0 and -1 when it cpontains null.

Tue, 18 Mar 2014 09:29:48 GMT

can you explain with an example...

Thanks

Helen

CELAMBARASAN — Tue, 18 Mar 2014 09:30:08 GMT

To add with it

It can be used simply

If(Not IsNull([Start_Date]), expr, expr)

Which is easily understandable, instead of writing those equal conditions its likely to compare.

its_anandrjs — Tue, 18 Mar 2014 09:33:34 GMT

Hi,

In this line means in [Start_Date] field if value is there means IsNull returns 0 and if value is not there(IsNull) then it returns -1

IsNull([Start_Date])=0

Try to plot a text box and write below code and you check this

=if(IsNull([Start_Date]) = 0, 'Date is there','Date is not there')

Thanks & Regards