topic Re: How to write if statement with not NULL ? in QlikView

How to write if statement with not NULL ?

Tue, 25 Nov 2014 06:54:52 GMT

Hello,

I have a field , from a SQL database that I would like to IF against :

If (fieldname NOT NULL, do this )

How would I write this like above, but correctly ?

ychaitanya — Tue, 25 Nov 2014 06:58:04 GMT

if( isNull('Fieldname'),'null conditon','not null conditon');

This will work..

Thanks

Chaitanya

sushil353 — Tue, 25 Nov 2014 06:58:34 GMT

Hi,

try below code:

If(not isnull(filedname) ,1,0)

HTH
Sushil

its_anandrjs — Tue, 25 Nov 2014 06:59:44 GMT

Try with

If( IsNull(fieldname) = 0, do this )

If( Not IsNull(fieldname), do this )

Regards

Anand

amit_saini — Tue, 25 Nov 2014 06:59:45 GMT

Try this:

=if (not isnull(Plant_ShortName),Plant_ShortName & ' - ' & Plant_FullName)

Thanks,

anbu1984 — Tue, 25 Nov 2014 06:59:59 GMT

If (IsNull(fieldname> <> -1, 'do this' )

Tue, 25 Nov 2014 07:07:57 GMT

Thanks , that worked perfectly !