How can I confine all NULL values in field in edit script?

[#1]

I want that my raport don't show any values if on of fields value is null?

I know how I do it in tables expression. But can I confine it in edit script? Then I do not need to do it in every table...

In SQL it is

LOAD*

FROM tableName

WHERE fieldName IS NOT NULL;

How I can Do it in QlikView?

[martin59]

Hi Aleksandra,

I think best way is something like that :

LOAD*
FROM tableName
WHERE len(trim(fieldName))>0;

However, you can try with one of thoses solutions, but functions won't be understand as well, depend on your system.

First solution :

LOAD *
FROM TableName
WERE fieldName = null();

Or

LOAD *
FROM tableName
WHERE IsNull(fieldName)=False();

Hope that helps you

Martin

[its_anandrjs]

Hi Martin,

Nice explanation that is correct way i find it works for my scenario thanks.

Regards.

Anand

[martin59]

I'm happy to help you !

[#5]

But... in my situation it don't works

[#6]

Hi,

you can also try it with:

LOAD *
FROM tableName
WHERE NOT IsNull(fieldName);

Regards,

Björn