topic Problems related to merging headers in pivot table in QlikView https://community.qlik.com/t5/QlikView/Problems-related-to-merging-headers-in-pivot-table/m-p/1052913#M522434 <HTML><HEAD></HEAD><BODY><P>Hi Community,</P><P><IMG alt="CaptureA.JPG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/120468_CaptureA.JPG" style="height: 219px; width: 620px;" /></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">I have followed the instruction from John in the previous discussion and it did work. However, I encounter another problem that there is a column without value appeared at the left side of the table. This column shows when I disabled 'Suppress Zero-Values' in the Presentation tab. I disable this because I would like to show the department with value in the table. How can I get rid of this column?</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Previous Discussion:<BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><A href="https://community.qlik.com/thread/3098">Merge headers in pivot table</A></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Maverick<BR /></SPAN></P></BODY></HTML> Tue, 05 Apr 2016 04:04:55 GMT 2016-04-05T04:04:55Z Problems related to merging headers in pivot table https://community.qlik.com/t5/QlikView/Problems-related-to-merging-headers-in-pivot-table/m-p/1052913#M522434 <HTML><HEAD></HEAD><BODY><P>Hi Community,</P><P><IMG alt="CaptureA.JPG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/120468_CaptureA.JPG" style="height: 219px; width: 620px;" /></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">I have followed the instruction from John in the previous discussion and it did work. However, I encounter another problem that there is a column without value appeared at the left side of the table. This column shows when I disabled 'Suppress Zero-Values' in the Presentation tab. I disable this because I would like to show the department with value in the table. How can I get rid of this column?</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Previous Discussion:<BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><A href="https://community.qlik.com/thread/3098">Merge headers in pivot table</A></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Maverick<BR /></SPAN></P></BODY></HTML> Tue, 05 Apr 2016 04:04:55 GMT https://community.qlik.com/t5/QlikView/Problems-related-to-merging-headers-in-pivot-table/m-p/1052913#M522434 2016-04-05T04:04:55Z Re: Problems related to merging headers in pivot table https://community.qlik.com/t5/QlikView/Problems-related-to-merging-headers-in-pivot-table/m-p/1052914#M522435 <HTML><HEAD></HEAD><BODY><P>Have you tried&nbsp; '<STRONG><EM>Suppress When value is Null</EM></STRONG>' Option in <STRONG>Dimension</STRONG> Tab ?</P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/120834_Capture.JPG" style="height: 325px; width: 620px;" /></P></BODY></HTML> Thu, 07 Apr 2016 03:45:52 GMT https://community.qlik.com/t5/QlikView/Problems-related-to-merging-headers-in-pivot-table/m-p/1052914#M522435 settu_periasamy 2016-04-07T03:45:52Z Re: Problems related to merging headers in pivot table https://community.qlik.com/t5/QlikView/Problems-related-to-merging-headers-in-pivot-table/m-p/1052915#M522436 <HTML><HEAD></HEAD><BODY><P>I have tried but it seems not working</P></BODY></HTML> Mon, 18 Apr 2016 08:09:33 GMT https://community.qlik.com/t5/QlikView/Problems-related-to-merging-headers-in-pivot-table/m-p/1052915#M522436 2016-04-18T08:09:33Z