topic Re: Pivot Table Dimensions in QlikView https://community.qlik.com/t5/QlikView/Pivot-Table-Dimensions/m-p/598338#M543484 <HTML><HEAD></HEAD><BODY><P>Thanks! </P></BODY></HTML> Mon, 05 May 2014 20:05:50 GMT Anonymous 2014-05-05T20:05:50Z Pivot Table Dimensions https://community.qlik.com/t5/QlikView/Pivot-Table-Dimensions/m-p/598336#M543482 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 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?</P><P></P><P>Kind Regards, </P><P>Isabel </P></BODY></HTML> Mon, 05 May 2014 19:43:22 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-Dimensions/m-p/598336#M543482 Anonymous 2014-05-05T19:43:22Z Re: Pivot Table Dimensions https://community.qlik.com/t5/QlikView/Pivot-Table-Dimensions/m-p/598337#M543483 <HTML><HEAD></HEAD><BODY><P>If all branches are collapsed (right-click on first dim and select "collapse all") then headers of the second and third dimension <SPAN style="text-decoration: underline;"><EM>are</EM></SPAN> 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.</P><P></P><P>HIC </P></BODY></HTML> Mon, 05 May 2014 19:55:15 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-Dimensions/m-p/598337#M543483 hic 2014-05-05T19:55:15Z Re: Pivot Table Dimensions https://community.qlik.com/t5/QlikView/Pivot-Table-Dimensions/m-p/598338#M543484 <HTML><HEAD></HEAD><BODY><P>Thanks! </P></BODY></HTML> Mon, 05 May 2014 20:05:50 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-Dimensions/m-p/598338#M543484 Anonymous 2014-05-05T20:05:50Z