topic Re: Remove blank column from pivot while exporting in QlikView https://community.qlik.com/t5/QlikView/Remove-blank-column-from-pivot-while-exporting/m-p/1027788#M347231 <HTML><HEAD></HEAD><BODY><P>It's not possible then this is header for your horizontal region-field. But you could remove the label Region and drag the column-width as small as possible.</P><P></P><P>- Marcus</P></BODY></HTML> Thu, 25 Feb 2016 16:35:19 GMT marcus_sommer 2016-02-25T16:35:19Z Remove blank column from pivot while exporting https://community.qlik.com/t5/QlikView/Remove-blank-column-from-pivot-while-exporting/m-p/1027787#M347230 <HTML><HEAD></HEAD><BODY><P>I have a qlikview pivot table as below:</P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/115964_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P><P>And when I export it to excel a blank column is added as highlighted below:</P><P><IMG class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/115965_pastedImage_1.png" style="max-height: 900px; max-width: 1200px;" /></P><P></P><P>Is there any way to restrict this column from exporting OR hide column header&nbsp; 'Region'&nbsp; ?</P></BODY></HTML> Thu, 25 Feb 2016 12:37:45 GMT https://community.qlik.com/t5/QlikView/Remove-blank-column-from-pivot-while-exporting/m-p/1027787#M347230 pooja_sn 2016-02-25T12:37:45Z Re: Remove blank column from pivot while exporting https://community.qlik.com/t5/QlikView/Remove-blank-column-from-pivot-while-exporting/m-p/1027788#M347231 <HTML><HEAD></HEAD><BODY><P>It's not possible then this is header for your horizontal region-field. But you could remove the label Region and drag the column-width as small as possible.</P><P></P><P>- Marcus</P></BODY></HTML> Thu, 25 Feb 2016 16:35:19 GMT https://community.qlik.com/t5/QlikView/Remove-blank-column-from-pivot-while-exporting/m-p/1027788#M347231 marcus_sommer 2016-02-25T16:35:19Z Re: Remove blank column from pivot while exporting https://community.qlik.com/t5/QlikView/Remove-blank-column-from-pivot-while-exporting/m-p/1027789#M347232 <HTML><HEAD></HEAD><BODY><P>yes. I have done that.</P></BODY></HTML> Fri, 26 Feb 2016 07:17:11 GMT https://community.qlik.com/t5/QlikView/Remove-blank-column-from-pivot-while-exporting/m-p/1027789#M347232 pooja_sn 2016-02-26T07:17:11Z