How to remove null values of a table in qlikview ?

[#1]

Hi,

   Anyone please tell me.

Thanks&Regards

Devi

[MayilVahanan]

Hi

For a particular column, try like this

If(Len(trim(FieldName)) , FieldName, 0) as FieldName.

Or

You need to remove all rows from the table. Try like this

Load * from table where len(trim(fieldname)) > 0;

based  on fieldname, it removes the null value.

[MK_QSL]

You can do this in script level

1) If you want to replace Null with something like 'Unknown'

IF(IsNull(FieldName) or IF(Len(Trim(Replace(FieldName,'-',''))) = 0 , 'Unknown', FieldName) as FieldName

2) If you want to remove all lines where FieldName is having NULL values

Load * From TableName

Where not IsNull(FieldName) or Len(Trim(Replace(FieldName,'-','')) > 0 

[jagan]

Hi,

Try like this

If you want to filter for 1 column

LOAD

*

FROM DataSource

WHERE Len(Trim(Column1)) > 0;

If you want to filter for more than 1 column

LOAD

*

FROM DataSource

WHERE Len(Trim(Column1)) > 0 AND Len(Trim(Column2)) > 0 ....................Len(Trim(ColumnN)) > 0;

Hope this helps you.

Regards,

Jagan.

[Anonymous]

Hi Devi,

By using isnull () function you can remove null from the table. And in place of null you can put 0.

Thanks

[MK_QSL]

Devi,

Below each answer given, you can find below buttons... Tick appropriate one...You can select Only one Correct and Two Helpful answers..

[#7]

Devi it doesn't take a second to answer which is correct. people like me are waiting for the correct post