topic Re: Group label for pivot table expressions in QlikView https://community.qlik.com/t5/QlikView/Group-label-for-pivot-table-expressions/m-p/656925#M543094 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>This is not possible directly.</P><P>there can be work around to play with text objects.</P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Wed, 11 Jun 2014 13:13:20 GMT ashfaq_haseeb 2014-06-11T13:13:20Z Group label for pivot table expressions https://community.qlik.com/t5/QlikView/Group-label-for-pivot-table-expressions/m-p/656923#M543092 <HTML><HEAD></HEAD><BODY><P>My need :</P><P></P><P>I have a pivot table with many many expressions.</P><P>Those expressions could be grouped by big categories.</P><P>I would like to set a label for each categories on top of each expression label.</P><P></P><P>It would look like this :</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"></TH><TH colspan="2" style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">group 1</TH><TH colspan="2" style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">group 2</TH></TR><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">expr 1</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">expr 2</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">expr 3</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">expr 4</TH></TR><TR><TD style="padding: 2px;">Dimension 1</TD><TD style="padding: 2px;">value</TD><TD style="padding: 2px;">value</TD><TD style="padding: 2px;">value</TD><TD style="padding: 2px;">value</TD></TR><TR><TD style="padding: 2px;">Dimension 2</TD><TD style="padding: 2px;">value</TD><TD style="padding: 2px;">value</TD><TD style="padding: 2px;">value</TD><TD style="padding: 2px;">value</TD></TR><TR><TD style="padding: 2px;">Dimension 3</TD><TD style="padding: 2px;">value</TD><TD style="padding: 2px;">value</TD><TD style="padding: 2px;">value</TD><TD style="padding: 2px;">value</TD></TR></TBODY></TABLE><P></P><P>I nedd that presentation in an Excel export based on this pivot table.</P><P></P><P>I haven't find any evident solution, so if someone as THE killer trick for that, i would be very grateful !</P></BODY></HTML> Wed, 11 Jun 2014 09:04:29 GMT https://community.qlik.com/t5/QlikView/Group-label-for-pivot-table-expressions/m-p/656923#M543092 2014-06-11T09:04:29Z Re: Group label for pivot table expressions https://community.qlik.com/t5/QlikView/Group-label-for-pivot-table-expressions/m-p/656924#M543093 <HTML><HEAD></HEAD><BODY><P>I'm not sure there is any easy way to do this <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P><P></P><P><A href="https://community.qlik.com/message/526689">Extending pivot table sub-total labels over several columns</A></P></BODY></HTML> Wed, 11 Jun 2014 13:08:39 GMT https://community.qlik.com/t5/QlikView/Group-label-for-pivot-table-expressions/m-p/656924#M543093 2014-06-11T13:08:39Z Re: Group label for pivot table expressions https://community.qlik.com/t5/QlikView/Group-label-for-pivot-table-expressions/m-p/656925#M543094 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>This is not possible directly.</P><P>there can be work around to play with text objects.</P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Wed, 11 Jun 2014 13:13:20 GMT https://community.qlik.com/t5/QlikView/Group-label-for-pivot-table-expressions/m-p/656925#M543094 ashfaq_haseeb 2014-06-11T13:13:20Z