Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sgarim41
Contributor III
Contributor III

Hiding a Pivot Table when all the values in a dimension are null

Hi,

Is there a way to hide a pivot table completely(including the headers) if all the values in a dimension are null or missing?

I have tried suppressing the dimension, but the header and borders for one row remain.

Regards,

Santosh

1 Solution

Accepted Solutions
sgarim41
Contributor III
Contributor III
Author

Actually i got it done by adding a formula in the layout tab, to conditionally show the table. Since null values length will always be 1, i set the condition to show th table only if the length is greater than 1.

View solution in original post

2 Replies
ogautier62
Specialist II
Specialist II

Hi,

I think you can do that with document actions :

on selection or sheet activation add an action

active object ( = your chart or table)

regards

sgarim41
Contributor III
Contributor III
Author

Actually i got it done by adding a formula in the layout tab, to conditionally show the table. Since null values length will always be 1, i set the condition to show th table only if the length is greater than 1.