Superpress Value when its null

[narender123]

Hi All,

I have a table like:

ID           In_Quantiaty             Out_Quantity             Amount

1               4                               2                              100

2                _                               _                               20

23              _                               _                               25

45              2                               1                              20

I want to superpress that rows whose In_quantity and Out_quantity  is NULL.

Means where ID =2 and ID=23  .I want to hide these rows as In_quantity and Out_quantity  is NULL.

Thanks,

Narender

[Kushal_Chawda]

LOAD *

FROM Table

Where len(trim(In_Quantiaty))=0 and len(trim(Out_Quantiaty))=0

[sujeetsingh]

Not sure you will be able to do it just with settings. You need to write calculated Dimension (ID) something like

=if(len(In_Quantity)>0,ID)

and then supress null in dimension setting.

This is the way to supress it in UI like straight table.

[jonathandienst]

I assume you mean "suppress". If you check the Suppress Zero Values (which is the default), the row will be suppressed if all expressions are zero or null. So in a straight table with ID as dimension, use the expressions:

sum(In_Quantity)

sum(Out_Quantity)

If(Sum(In_Quantity) <> 0 Or Sum(Out_Quantity) <> 0, Amount)

[qlikview979]

Try this ,

T1:

load * Inline [

ID ,In_Quantiaty,Out_Quantity,Amount

1  ,4          ,2          ,100

2  ,-          ,-        ,20

23  , -        ,-        ,25

45 ,2          , 1          ,20

];

NoConcatenate

T2:

load

ID,

In_Quantiaty,

Out_Quantity,

Amount

Resident T1 Where In_Quantiaty<>Chr(45) and Out_Quantity<>Chr(45);

DROP table T1;

[qlikview979]

Try like this.

T1:

load * Inline [

ID ,In_Quantiaty,Out_Quantity,Amount

1  ,4          ,2          ,100

2  ,-          ,-        ,20

23  , -        ,-        ,25

45 ,2          , 1          ,20

];

NoConcatenate

T2:

load

ID,

In_Quantiaty,

Out_Quantity,

Amount

Resident T1 Where In_Quantiaty<>Chr(45) and Out_Quantity<>Chr(45);

DROP table T1;