topic Re: Removing Null values in the script? in QlikView

Removing Null values in the script?

chinnu123 — Tue, 27 Oct 2015 21:29:48 GMT

Hi Community,

In my data there are nulls I need to remove that null data in the script it self. i don't want to load that nulls data in to qlik.

can any one suggest it how to achieve it?

Thanks in Advance

Regards,

Chinnu.

Re: Removing Null values in the script?

swuehl — Tue, 27 Oct 2015 21:34:15 GMT

LOAD Data

FROM ...

WHERE LEN(TRIM(Data));

LOAD

IF(LEN(TRIM(Data)), Data, 'No data') AS Data

FROM ...;

Re: Removing Null values in the script?

Tue, 27 Oct 2015 21:45:34 GMT

Chinnu,

Using Qlikview null functions we can handle this.

we can write a case logic like

if (isnull(fieldname)=-1,'No Data',fieldname) as fieldname.

But if instead of null if your data have space or anything besides null showing as null, use TRIM function as Swuehl mentioned above.

Thanks

Brad.

Re: Removing Null values in the script?

chinnu123 — Tue, 27 Oct 2015 21:49:20 GMT

Hi swuehl,

Thanks for your quick reply,

I want to delete that null values data permanently instead of changing as some other name.

for example i have a field name ISSUES in this field i have some null values '-' i want to remove that data permanently.

Regards,

Chinnu.

Re: Removing Null values in the script?

swuehl — Tue, 27 Oct 2015 21:51:28 GMT

If you want to remove these records where ISSUES is NULL, then just use the WHERE clause:

LOAD ISSUES,

AnotherField

FROM ...

WHERE LEN(TRIM(ISSUES));

Re: Removing Null values in the script?

Anonymous — Tue, 27 Oct 2015 22:56:02 GMT

Hi,

Load

Data..

from

where Field is not null;

Regards

Re: Removing Null values in the script?

MarcoWedel — Tue, 27 Oct 2015 23:05:23 GMT

Hi,

for "real" null values you could use:

...
Where not IsNull(YourField);

but that would not work for e.g. blanks or empty strings.

hope this helps

regards

Marco

Re: Removing Null values in the script?

chinnu123 — Tue, 27 Oct 2015 23:15:20 GMT

Thanks Swuehl,

Its working...