How to Hide Dimension

peter_rtf06 — Thu, 14 Oct 2010 17:52:18 GMT

Hi.

I have a pivot table like this....

Country	City	TOTAL	Jan	Feb	Mar	Apr
Panama	City1	0	0	0	0	0
	City2	10	1	3	4	2
Costa Rica	City1	0	0	0	0	0
	City2	0	0	0	0	0
Colombia	City1	7	1	0	2	4
	City2	0	0	0	0	0
Peru	City1	15	6	5	0	4
	City2	17	5	8	3	1

I need to eliminate the dimensions "City1" and "City2" only when both are zero(0) in the total column (Red colored rows). Only in that case because If one of Those dimension has a value diferent of 0, I need to show both (even the row with the 0 value)

Sorry for my bad English and thank you.....

How to Hide Dimension

vgutkovsky — Fri, 15 Oct 2010 00:23:47 GMT

In the Presentation tab, is "Suppress Zero Values" checked? If so, then the row should be suppressed when all expression values = 0.

Regards,

topic How to Hide Dimension in QlikView

How to Hide Dimension

How to Hide Dimension