How exclude Rows from table?

[#1]

I have next script:

LOAD * INLINE [

    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

];

LOAD * INLINE [

    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?

[its_anandrjs]

Hi,

Use Supress When Value is null

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

HTH

Regards,

Anand

[renjithpl]

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

[#4]

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

[Gysbert_Wassenaar · Accepted solution]

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

[#6]

Thank you very much!