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?
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.
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.
.png "Former Employee"){kind=icon}