How to skip the row in a table, when field is null?

[#1]

Hi QV Team,

I've a Serial # field in a table, I need to skip the entire row when the Serial # record is Missing/Null.

Help me out !!

[anbu1984]

In Script

Load * From Table where Len(Trim([Serial #])) > 0;

[its_anandrjs]

Hi,

If you want to remove it from the chart you can use

Suppress When Value Is Null option

And you can read more on the NULL Handelling

NULL handling in QlikView

Regards

Anand

[#4]

Hi Anand,

Where is this option " Suppress when Value is NULL" on Table box object ?

[its_anandrjs · Accepted solution]

In Table box it is not available it is in charts only you can remove it in the load script then and read that columns

You can create the filters in load script or completely remove it as Anbu suggest from loadscript

lOAD iF(len(ColA) > 0,'Null','NotNull')  AS NullFlagA,

         iF(len(ColB) > 0,'Null','NotNull')  AS NullFlagB,

         ColA,ColB;

LOAD * Inline  [

ColA,ColB

A,5443

B,56

,45

D,54

E,

F,54  ];

Regards

Anand

[amit_saini]

Try something like below:

=if (not isnull(Plant),Plant )

Thanks,
AS

[its_anandrjs]

Hi,

In place of the Table box you can use the straight table also by adding all the dimension and in expression write 1. And use option Suppress When Value Is Null from chart Properties >> Dimensions >> Select Null dimension >> Tick mark Suppress When value is null OR From Presentation >> Suppress Zero-Values tick mark all this if you do not want to do change in the load script.

Regards

Anand

[amit_saini]

Try this also:

=if(Len(Trim(Your_Feild))>0 , Your_Field)

Thanks,

AS

[its_anandrjs]

Or you can use the single filter also

iF(len(Trim(ColA)) > 0 and len(Trim(ColB)) > 0,'Null','NotNull')  AS NullFlagA,

Regards

Anand