Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Specialist II
Specialist II

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
Specialist II
Specialist II

I'm happy to help you !

Not applicable
Author

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

Not applicable
Author

Hi,

you can also try it with:


LOAD *
FROM tableName
WHERE NOT IsNull(fieldName);

Regards,

Björn