Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Hiding rows in a Pivot Table. Is it possible?

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

Captura.JPG

Thanks in advance!!

1 Solution

Accepted Solutions
whiteline
Master II
Master II

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).

View solution in original post

2 Replies
whiteline
Master II
Master II

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).

Not applicable
Author

Ok!! Thanks