topic Re: Remove null value keyword from data field in QlikView

Remove null value keyword from data field

Aspiring_Developer — Wed, 24 Feb 2021 06:37:53 GMT

Hello everyone,

I have a below data column:-

I want to remove this 'NULL' key word , i tried below :-

Table:

Load

tag_color

from....

where tag_color <>'NULL'

It did not work , i am still able to see the NULL value in the data column.

Can anyone please help ?

Re: Remove null value keyword from data field

MayilVahanan — Wed, 24 Feb 2021 06:47:46 GMT

Hi @Aspiring_Developer

Try with below

Load

tag_color

from....

where IsNum(tag_color );

Re: Remove null value keyword from data field

Aspiring_Developer — Wed, 24 Feb 2021 07:00:19 GMT

Hi @MayilVahanan

When i apply the query like below:-

Data :

Load tag_color

from...

where tag_color <> 'NULL' and run the script, NULL is removed.

However, when i try to do the below :-

Data

Load tag_color,

tga_uid..

tag_changedate

tag_trolleyid

..from ...

Temp:

tag_uid

max(tag_changedate) as Last_date_paint

resident Data

Where tag_color <> 'NULL'

group by tag_uid;

When i create table it does not work (tag_color ) show values for both (NULL and numbers)

IS it becuse both the tables have common key as tga_uid linking them ?

Re: Remove null value keyword from data field

MayilVahanan — Wed, 24 Feb 2021 07:30:24 GMT

Hi @Aspiring_Developer

Yes, its might be due to tag_id.
If you don't want "NULL" value in ur app. You can apply where condition in initial load itself.

Re: Remove null value keyword from data field

Aspiring_Developer — Wed, 24 Feb 2021 07:40:00 GMT

Hi @MayilVahanan

I want both tables

One table where tag_color ='NULL'

and other table where tag_color <>'NULL'

How can i achieve it ?

Re: Remove null value keyword from data field

MayilVahanan — Wed, 24 Feb 2021 08:12:34 GMT

Can you send the sample data & expected output to proceed further.