5 Replies Latest reply: Nov 18, 2012 9:54 AM by Max Pol

How exclude Rows from table?

I have next script:

INV, QTYINV, DATAINV

N1, 100, 01.01.2012

N2, 1000, 01.02.2012

N3, 6000, 01.03.2012

N4, 1500, 01.04.2012

N5, 900, 01.05.2012

N6, 1200, 01.06.2012

];

SHI, INV, QTYSHI, DATASHI

P1, N1, 100, 15.01.2012

P2, N2, 800, 15.02.2012

P3, N2, 100, 16.02.2012

P4, N3, 5000, 15.03.2012

P5, N3, 1000, 16.03.2012

P6, N4, 1400, 15.04.2012

P7, N5, 700, 15.05.2012

P8, N6, 1200, 15.06.2012

];

And I have in diagramm Table:

Colomn1 Dimension:

INV

Colomn 2 Expression:

QTYINV-Sum({1}QTYSHI)

Colomn 3 Expression:

DATASHI-DATAINV

I need, that in the table will be the rows, where Colomn 2 <> 0.

Nowday I have this:

 INV COLOMN 2 DATASHI-DATAINV - - N1 0 14 N2 100 - N4 100 14 N5 200 14 N6 0 14

But I need:

 INV COLOMN 2 DATASHI-DATAINV N2 100 - N4 100 14 N5 200 14

Please, help me, how I can exclude Rows?

• Re: How exclude Rows from table?

Hi,

Use Supress When Value is null

In the Chart property in Dimensions tab select ->Supress When Value is Null

HTH

Regards,

Anand

• Re: How exclude Rows from table?

Under dimension tab, check "Supress When Value is Null"

• Re: How exclude Rows from table?

It work if I have Colomn 2 only. When I add Colomn 3 (DATASHI-DATAINV), "0" from Colomn 2 comeback.

• Re: How exclude Rows from table?

See attached qvw. Is that what you need? I use a calculated dimension, suppress null values for that column and hide it.

• Re: How exclude Rows from table?

Thank you very much!