Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
See attached qvw. Is that what you need? I use a calculated dimension, suppress null values for that column and hide it.
Hi,
Use Supress When Value is null
In the Chart property in Dimensions tab select ->Supress When Value is Null
HTH
Regards,
Anand
Under dimension tab, check "Supress When Value is Null"
It work if I have Colomn 2 only. When I add Colomn 3 (DATASHI-DATAINV), "0" from Colomn 2 comeback.
See attached qvw. Is that what you need? I use a calculated dimension, suppress null values for that column and hide it.
Thank you very much!