topic Merge Cells of Pivot table in QlikView

topic Merge Cells of Pivot table in QlikView https://community.qlik.com/t5/QlikView/Merge-Cells-of-Pivot-table/m-p/1136732#M916940 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>Below is a pivot table i want to make:-<SPAN style="font-size: 10pt;">      </SPAN></P><P>     </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 325px;"><TBODY><TR><TD class="xl63" height="15" width="65">DIm1</TD><TD class="xl63" style="border-left: none;" width="65">Exp1</TD><TD class="xl63" style="border-left: none;" width="65">Exp2</TD><TD class="xl63" style="border-left: none;" width="65">Exp3</TD><TD class="xl63" style="border-left: none;" width="65">Exp4</TD></TR><TR><TD class="xl63" height="15" style="border-top: none;">Dim_val1</TD><TD class="xl63" style="border-top: none; border-left: none;">t1</TD><TD align="right" class="xl63" rowspan="2" style="border-top: none;">121</TD><TD class="xl63" rowspan="2" style="border-top: none;">v1</TD><TD class="xl63" rowspan="2" style="border-top: none;"></TD></TR><TR><TD class="xl63" height="15" style="border-top: none;">Dim_val2</TD><TD class="xl63" style="border-top: none; border-left: none;">t2</TD></TR><TR><TD class="xl63" height="15" style="border-top: none;">Dim_val3</TD><TD class="xl63" style="border-top: none; border-left: none;">t3</TD><TD align="right" class="xl63" rowspan="2" style="border-top: none;">121</TD><TD class="xl63" rowspan="2" style="border-top: none;">v2</TD><TD class="xl63" rowspan="2" style="border-top: none;"></TD></TR><TR><TD class="xl63" height="15" style="border-top: none;">Dim_val4</TD><TD class="xl63" style="border-top: none; border-left: none;">t4</TD></TR><TR><TD class="xl63" height="15" style="border-top: none;">Dim_val5</TD><TD class="xl63" style="border-top: none; border-left: none;">t5</TD><TD align="right" class="xl63" rowspan="2" style="border-top: none;">121</TD><TD class="xl63" rowspan="2" style="border-top: none;">v3</TD><TD class="xl63" rowspan="2" style="border-top: none;"></TD></TR><TR><TD class="xl63" height="15" style="border-top: none;">Dim_val6</TD><TD class="xl63" style="border-top: none; border-left: none;">t6</TD></TR></TBODY></TABLE><P></P><P></P><P>I want to merge row 1,2 for Exp2, Exp3, Exp4</P><P>merge row 3,4 for Exp2, Exp3, Exp4</P><P>merge row 5,6 for Exp2, Exp3, Exp4</P><P></P><P>How can this be achieved. ?</P><P></P><P>Thanks</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z Merge Cells of Pivot table https://community.qlik.com/t5/QlikView/Merge-Cells-of-Pivot-table/m-p/1136732#M916940 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>Below is a pivot table i want to make:-<SPAN style="font-size: 10pt;">      </SPAN></P><P>     </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 325px;"><TBODY><TR><TD class="xl63" height="15" width="65">DIm1</TD><TD class="xl63" style="border-left: none;" width="65">Exp1</TD><TD class="xl63" style="border-left: none;" width="65">Exp2</TD><TD class="xl63" style="border-left: none;" width="65">Exp3</TD><TD class="xl63" style="border-left: none;" width="65">Exp4</TD></TR><TR><TD class="xl63" height="15" style="border-top: none;">Dim_val1</TD><TD class="xl63" style="border-top: none; border-left: none;">t1</TD><TD align="right" class="xl63" rowspan="2" style="border-top: none;">121</TD><TD class="xl63" rowspan="2" style="border-top: none;">v1</TD><TD class="xl63" rowspan="2" style="border-top: none;"></TD></TR><TR><TD class="xl63" height="15" style="border-top: none;">Dim_val2</TD><TD class="xl63" style="border-top: none; border-left: none;">t2</TD></TR><TR><TD class="xl63" height="15" style="border-top: none;">Dim_val3</TD><TD class="xl63" style="border-top: none; border-left: none;">t3</TD><TD align="right" class="xl63" rowspan="2" style="border-top: none;">121</TD><TD class="xl63" rowspan="2" style="border-top: none;">v2</TD><TD class="xl63" rowspan="2" style="border-top: none;"></TD></TR><TR><TD class="xl63" height="15" style="border-top: none;">Dim_val4</TD><TD class="xl63" style="border-top: none; border-left: none;">t4</TD></TR><TR><TD class="xl63" height="15" style="border-top: none;">Dim_val5</TD><TD class="xl63" style="border-top: none; border-left: none;">t5</TD><TD align="right" class="xl63" rowspan="2" style="border-top: none;">121</TD><TD class="xl63" rowspan="2" style="border-top: none;">v3</TD><TD class="xl63" rowspan="2" style="border-top: none;"></TD></TR><TR><TD class="xl63" height="15" style="border-top: none;">Dim_val6</TD><TD class="xl63" style="border-top: none; border-left: none;">t6</TD></TR></TBODY></TABLE><P></P><P></P><P>I want to merge row 1,2 for Exp2, Exp3, Exp4</P><P>merge row 3,4 for Exp2, Exp3, Exp4</P><P>merge row 5,6 for Exp2, Exp3, Exp4</P><P></P><P>How can this be achieved. ?</P><P></P><P>Thanks</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Merge-Cells-of-Pivot-table/m-p/1136732#M916940 2020-11-25T16:16:04Z