topic Re: how to hide single column in pivot table in QlikView https://community.qlik.com/t5/QlikView/how-to-hide-single-column-in-pivot-table/m-p/1277735#M861404 <HTML><HEAD></HEAD><BODY><P>If you hide your only expression then the chart will have nothing to show?</P></BODY></HTML> Thu, 05 Jan 2017 13:09:18 GMT adamdavi3s 2017-01-05T13:09:18Z how to hide single column in pivot table https://community.qlik.com/t5/QlikView/how-to-hide-single-column-in-pivot-table/m-p/1277734#M861403 <HTML><HEAD></HEAD><BODY><P><IMG alt="sample.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/148409_sample.png" style="height: auto;" /></P><P>from above pivot table i want to hide sum(amount) column.</P><P></P><P></P><P></P><P>thanks,</P><P>Yuvaraj </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/how-to-hide-single-column-in-pivot-table/m-p/1277734#M861403 Anonymous 2020-11-25T16:16:04Z Re: how to hide single column in pivot table https://community.qlik.com/t5/QlikView/how-to-hide-single-column-in-pivot-table/m-p/1277735#M861404 <HTML><HEAD></HEAD><BODY><P>If you hide your only expression then the chart will have nothing to show?</P></BODY></HTML> Thu, 05 Jan 2017 13:09:18 GMT https://community.qlik.com/t5/QlikView/how-to-hide-single-column-in-pivot-table/m-p/1277735#M861404 adamdavi3s 2017-01-05T13:09:18Z Re: how to hide single column in pivot table https://community.qlik.com/t5/QlikView/how-to-hide-single-column-in-pivot-table/m-p/1277736#M861405 <HTML><HEAD></HEAD><BODY><P>What is the point of showing this chart without Sum(amount)?</P></BODY></HTML> Thu, 05 Jan 2017 13:15:24 GMT https://community.qlik.com/t5/QlikView/how-to-hide-single-column-in-pivot-table/m-p/1277736#M861405 sunny_talwar 2017-01-05T13:15:24Z Re: how to hide single column in pivot table https://community.qlik.com/t5/QlikView/how-to-hide-single-column-in-pivot-table/m-p/1277737#M861406 <HTML><HEAD></HEAD><BODY><P>Unlike Straight table, hide or show column feature is not available in Pivot table.</P><P>What is that you are trying to achieve having a pivot table with multiple dimension but no measure (expression) ?</P><P></P><P>If it purely for cosmetic reason, there are a few ways to do:</P><OL><LI>hit spacebar in the Expression Label box (to give it a blank value)</LI><LI>change the representation to LED GAUGE and in the Gauge setting, make the color transparent</LI><LI>Then squeeze the column border to reduce the width as much possible<IMG alt="image1.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/148504_image1.PNG" style="height: 329px; width: 620px;" /></LI></OL></BODY></HTML> Fri, 06 Jan 2017 01:02:26 GMT https://community.qlik.com/t5/QlikView/how-to-hide-single-column-in-pivot-table/m-p/1277737#M861406 Anonymous 2017-01-06T01:02:26Z