topic Merge Cells in pivot table in QlikView https://community.qlik.com/t5/QlikView/Merge-Cells-in-pivot-table/m-p/1431851#M814020 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I am trying to merge some cells on a pivot table, but i haven´t been able to do it.</P><P></P><P>¿Is there any way to do?</P><P></P><P>I attach an example of a pivot table.</P><P></P><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 456px;"><TBODY><TR><TD class="xl63" height="17" width="98">SALESMAN</TD><TD class="xl63" style="border-left: none;" width="98">PRODUCT</TD><TD class="xl64" style="border-left: none;" width="98">KPI</TD><TD class="xl65" width="98">sum(SALES)</TD><TD class="xl66" width="64">sales</TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">X</TD><TD class="xl65" style="border-top: none; border-left: none;">1</TD><TD class="xl65" style="border-top: none; border-left: none;">SALES</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">5</TD><TD class="xl68" rowspan="2">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12</TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">X</TD><TD class="xl65" style="border-top: none; border-left: none;">2</TD><TD class="xl65" style="border-top: none; border-left: none;">SALES</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">7</TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">Y</TD><TD class="xl65" style="border-top: none; border-left: none;">3</TD><TD class="xl65" style="border-top: none; border-left: none;">SALES</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">9</TD><TD align="right">9</TD></TR></TBODY></TABLE><P></P><P></P><P>thank you</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z Merge Cells in pivot table https://community.qlik.com/t5/QlikView/Merge-Cells-in-pivot-table/m-p/1431851#M814020 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I am trying to merge some cells on a pivot table, but i haven´t been able to do it.</P><P></P><P>¿Is there any way to do?</P><P></P><P>I attach an example of a pivot table.</P><P></P><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 456px;"><TBODY><TR><TD class="xl63" height="17" width="98">SALESMAN</TD><TD class="xl63" style="border-left: none;" width="98">PRODUCT</TD><TD class="xl64" style="border-left: none;" width="98">KPI</TD><TD class="xl65" width="98">sum(SALES)</TD><TD class="xl66" width="64">sales</TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">X</TD><TD class="xl65" style="border-top: none; border-left: none;">1</TD><TD class="xl65" style="border-top: none; border-left: none;">SALES</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">5</TD><TD class="xl68" rowspan="2">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12</TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">X</TD><TD class="xl65" style="border-top: none; border-left: none;">2</TD><TD class="xl65" style="border-top: none; border-left: none;">SALES</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">7</TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">Y</TD><TD class="xl65" style="border-top: none; border-left: none;">3</TD><TD class="xl65" style="border-top: none; border-left: none;">SALES</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">9</TD><TD align="right">9</TD></TR></TBODY></TABLE><P></P><P></P><P>thank you</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Merge-Cells-in-pivot-table/m-p/1431851#M814020 Anonymous 2020-11-25T16:16:04Z Re: Merge Cells in pivot table https://community.qlik.com/t5/QlikView/Merge-Cells-in-pivot-table/m-p/1431852#M814021 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">Hi,</P><P style="font-size: 13.3333px;">Like this?</P><P style="font-size: 13.3333px;">create expression like below</P><P style="font-size: 13.3333px;">aggr(sum(SALES),SALESMAN)</P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/176912_Capture.JPG" style="max-width: 620px; height: auto;" /></P></BODY></HTML> Mon, 18 Sep 2017 09:48:48 GMT https://community.qlik.com/t5/QlikView/Merge-Cells-in-pivot-table/m-p/1431852#M814021 devarasu07 2017-09-18T09:48:48Z Re: Merge Cells in pivot table https://community.qlik.com/t5/QlikView/Merge-Cells-in-pivot-table/m-p/1431853#M814022 <HTML><HEAD></HEAD><BODY><P>Like this?</P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/176909_Capture.PNG" style="height: auto;" /></P><P></P><P>OR</P><P><STRONG>Sum(Aggr(sum(SALES), SALESMAN))</STRONG></P></BODY></HTML> Mon, 18 Sep 2017 09:50:12 GMT https://community.qlik.com/t5/QlikView/Merge-Cells-in-pivot-table/m-p/1431853#M814022 Anil_Babu_Samineni 2017-09-18T09:50:12Z