Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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