Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Thanks!