Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

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

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?

5 Replies
martin59
Valued Contributor II

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

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

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

Hi Martin,

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

Regards.

Anand

martin59
Valued Contributor II

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

I'm happy to help you !

Not applicable

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

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

Not applicable

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

Hi,

you can also try it with:


LOAD *
FROM tableName
WHERE NOT IsNull(fieldName);

Regards,

Björn

Community Browser