Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

inowinowski
New Contributor

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
Employee
Employee

Re: Pivot Table Dimensions

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

2 Replies
Employee
Employee

Re: Pivot Table Dimensions

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

inowinowski
New Contributor

Re: Pivot Table Dimensions

Thanks!

Community Browser