topic custom row in pivot table in QlikView

topic custom row in pivot table in QlikView https://community.qlik.com/t5/QlikView/custom-row-in-pivot-table/m-p/719599#M540086 <HTML><HEAD></HEAD><BODY><P>Hi all !</P><P></P><P>I have a pivot table in my qlikview application like the following:</P><P></P><TABLE border="1" class="jiveBorder" jive-data-cell="{"color":"#575757","textAlign":"left","padding":"2","backgroundColor":"transparent","fontFamily":"arial,helvetica,sans-serif","verticalAlign":"baseline"}" jive-data-header="{"color":"#FFFFFF","backgroundColor":"#6690BC","textAlign":"center","padding":"2"}" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Dimension1</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><SPAN style="color: #ffffff; text-align: center; background-color: #6690bc;">Dimension2</SPAN></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG style="color: #ffffff; text-align: center;">Expression1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG style="color: #ffffff; text-align: center;">Expression2</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG style="color: #ffffff; text-align: center;">Expression3</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG><STRONG style="color: #ffffff; text-align: center;">Expression4</STRONG><BR /></STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG style="color: #ffffff; text-align: center;">Expression5</STRONG></TH></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE><P></P><P>I want to add a new custom row above the expression title row :</P><P></P><TABLE border="1" class="jiveBorder" jive-data-cell="{"color":"#575757","textAlign":"left","padding":"NaN","backgroundColor":"transparent","fontFamily":"arial,helvetica,sans-serif","verticalAlign":"baseline"}" jive-data-header="{"color":"#FFFFFF","backgroundColor":"#6690BC","textAlign":"center","padding":"2"}" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TD colspan="1"></TD><TD colspan="1"></TD><TD colspan="3" style="text-align: center;"><P><STRONG>GROUP1</STRONG></P></TD><TD colspan="2" style="text-align: center;"><STRONG>GROUP2</STRONG></TD></TR><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Dimension1</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><SPAN style="color: #ffffff; text-align: center; background-color: #6690bc;">Dimension2</SPAN></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG style="color: #ffffff; text-align: center;">Expression1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG style="color: #ffffff; text-align: center;">Expression2</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG style="color: #ffffff; text-align: center;">Expression3</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG><STRONG style="color: #ffffff; text-align: center;">Expression4</STRONG><BR /></STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG style="color: #ffffff; text-align: center;">Expression5</STRONG></TH></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE><P></P><P>Do you have any idea pls?</P><P></P><P>Regards,</P><P>Yacine</P></BODY></HTML> Mon, 21 Jul 2014 15:34:16 GMT 2014-07-21T15:34:16Z custom row in pivot table https://community.qlik.com/t5/QlikView/custom-row-in-pivot-table/m-p/719599#M540086 <HTML><HEAD></HEAD><BODY><P>Hi all !</P><P></P><P>I have a pivot table in my qlikview application like the following:</P><P></P><TABLE border="1" class="jiveBorder" jive-data-cell="{"color":"#575757","textAlign":"left","padding":"2","backgroundColor":"transparent","fontFamily":"arial,helvetica,sans-serif","verticalAlign":"baseline"}" jive-data-header="{"color":"#FFFFFF","backgroundColor":"#6690BC","textAlign":"center","padding":"2"}" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Dimension1</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><SPAN style="color: #ffffff; text-align: center; background-color: #6690bc;">Dimension2</SPAN></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG style="color: #ffffff; text-align: center;">Expression1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG style="color: #ffffff; text-align: center;">Expression2</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG style="color: #ffffff; text-align: center;">Expression3</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG><STRONG style="color: #ffffff; text-align: center;">Expression4</STRONG><BR /></STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG style="color: #ffffff; text-align: center;">Expression5</STRONG></TH></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE><P></P><P>I want to add a new custom row above the expression title row :</P><P></P><TABLE border="1" class="jiveBorder" jive-data-cell="{"color":"#575757","textAlign":"left","padding":"NaN","backgroundColor":"transparent","fontFamily":"arial,helvetica,sans-serif","verticalAlign":"baseline"}" jive-data-header="{"color":"#FFFFFF","backgroundColor":"#6690BC","textAlign":"center","padding":"2"}" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TD colspan="1"></TD><TD colspan="1"></TD><TD colspan="3" style="text-align: center;"><P><STRONG>GROUP1</STRONG></P></TD><TD colspan="2" style="text-align: center;"><STRONG>GROUP2</STRONG></TD></TR><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Dimension1</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><SPAN style="color: #ffffff; text-align: center; background-color: #6690bc;">Dimension2</SPAN></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG style="color: #ffffff; text-align: center;">Expression1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG style="color: #ffffff; text-align: center;">Expression2</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG style="color: #ffffff; text-align: center;">Expression3</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG><STRONG style="color: #ffffff; text-align: center;">Expression4</STRONG><BR /></STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG style="color: #ffffff; text-align: center;">Expression5</STRONG></TH></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE><P></P><P>Do you have any idea pls?</P><P></P><P>Regards,</P><P>Yacine</P></BODY></HTML> Mon, 21 Jul 2014 15:34:16 GMT https://community.qlik.com/t5/QlikView/custom-row-in-pivot-table/m-p/719599#M540086 2014-07-21T15:34:16Z