topic Re: Hiding rows in a Pivot Table. Is it possible? in QlikView

Hiding rows in a Pivot Table. Is it possible?

Tue, 11 Sep 2012 08:36:19 GMT

Hi I have a Pivot Table with 1 Dimension ( A value List with 2 Values "Tax" + "Amount") and several expresions related with the VAT TAX. Not every month these expressions have values, most of the time their value is 0. What I would like to know if it's possible to Hide ( or not tho show) a row (expression) when its value is 0.

Here's a picture

Thanks in advance!!

Re: Hiding rows in a Pivot Table. Is it possible?

whiteline — Tue, 11 Sep 2012 09:45:51 GMT

Hi.

There is a checkbox 'supress zero-values' on presentation tab.

upd:

Ok, but it doesn't work for expressions

If you use QV11 you can show your expression conditionally (toggle check box Conditional on expressions tab and write a check expression).

Re: Hiding rows in a Pivot Table. Is it possible?

Tue, 11 Sep 2012 11:00:14 GMT

Ok!! Thanks