How to delete all NULL values from field?

[ridleyyeh]

I've searching about "how to delete NULL Values from qliksense?"

And none of those could actually work on my files.

My data came from excel.

As you can see, there're so many NULL in "CallTime' and'VerifyTime'.

And i expect that i can remove those NULL data somehow.

Can anyone help with these ? Thank you !

[jonathandienst]

You can't 'delete values from a field' (other than setting it no null).  Do you mean delete/suppress the record if there are nulls in any field values or replace the nulls with some default value?

[nagarjuna_kotha]

May be you can try this way:

Example describes below:

Table:

ID,Name,Time1,Time2

From..............

Logic:

Load *,

if(Isnull(Time1),0,1) as Flag1,

if(Isnull(Time2),0,1) as Flag2

Resident Table;

Drop Table Table;

Result:

Load ID,Name,Time1,Time2

Resident Logic

where Flag1<>0 and Flag2<>0;

Drop Table Logic ;

I hope this helps;

Regards,

Nagarjun