topic Re: How exclude Rows from table? in QlikView

How exclude Rows from table?

Sun, 18 Nov 2012 14:17:04 GMT

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?

Re: How exclude Rows from table?

its_anandrjs — Sun, 18 Nov 2012 14:19:37 GMT

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?

renjithpl — Sun, 18 Nov 2012 14:21:09 GMT

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

Re: How exclude Rows from table?

Sun, 18 Nov 2012 14:25:59 GMT

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?

Gysbert_Wassenaar — Sun, 18 Nov 2012 14:50:06 GMT

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?

Sun, 18 Nov 2012 14:54:19 GMT

Thank you very much!