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: 
Anonymous
Not applicable

Pivot Table Dimensions

Hi,

       I have a question regarding Pivot Tables In Qlik. I have three dimensions and four expressions. Is it possible to hide the second and third dimension headers if they are collapsed and there is no value for them?

Kind Regards,

Isabel

1 Solution

Accepted Solutions
hic
Former Employee
Former Employee

If all branches are collapsed (right-click on first dim and select "collapse all") then headers of the second and third dimension are hidden. But if they are expanded and there is no value (just NULL), then they cannot be hidden: The dimension is still needed as a formal iterator (loop counter) in the chart.

HIC

View solution in original post

2 Replies
hic
Former Employee
Former Employee

If all branches are collapsed (right-click on first dim and select "collapse all") then headers of the second and third dimension are hidden. But if they are expanded and there is no value (just NULL), then they cannot be hidden: The dimension is still needed as a formal iterator (loop counter) in the chart.

HIC

Anonymous
Not applicable
Author

Thanks!