topic Re: Superpress Value when its null in QlikView

Superpress Value when its null

narender123 — Mon, 23 May 2016 06:37:54 GMT

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

Re: Superpress Value when its null

Kushal_Chawda — Mon, 23 May 2016 06:41:05 GMT

LOAD *

FROM Table

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

Re: Superpress Value when its null

sujeetsingh — Mon, 23 May 2016 06:43:58 GMT

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.

Re: Superpress Value when its null

jonathandienst — Mon, 23 May 2016 06:45:01 GMT

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)

Re: Superpress Value when its null

qlikview979 — Mon, 23 May 2016 08:18:08 GMT

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;

Re: Superpress Value when its null

qlikview979 — Mon, 23 May 2016 09:04:55 GMT

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;