topic Merged heading over 3 dimensions in a pivot table in QlikView https://community.qlik.com/t5/QlikView/Merged-heading-over-3-dimensions-in-a-pivot-table/m-p/359130#M578870 <HTML><HEAD></HEAD><BODY><P> What if you just name the dimension Iron "Threshold" and leave other two blank?</P></BODY></HTML> Tue, 20 Mar 2012 08:11:29 GMT 2012-03-20T08:11:29Z Merged heading over 3 dimensions in a pivot table https://community.qlik.com/t5/QlikView/Merged-heading-over-3-dimensions-in-a-pivot-table/m-p/359129#M578869 <HTML><HEAD></HEAD><BODY><TABLE bgcolor="#ffffff" border="1" cellpadding="2" cellspacing="0" style="font-size: 9pt;"><TBODY><TR align="left" bgcolor="#f5f5f5"><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Categories<STRONG> </STRONG></STRONG></SPAN></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><SPAN style="color: #363636;"><STRONG>Measurement</STRONG></SPAN> </SPAN></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><SPAN style="color: #363636;"><STRONG>Description</STRONG></SPAN> </SPAN></TH><TH nowrap="nowrap"></TH><TH nowrap="nowrap"></TH><TH nowrap="nowrap"></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><SPAN style="color: #363636;"><STRONG>sum(Amount)</STRONG></SPAN> </SPAN></TH></TR><TR align="left" bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Industries</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Tonage</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Tonage mined</SPAN> </TD><TD bgcolor="#00ff00"><SPAN style="color: #363636;">Gold</SPAN> </TD><TD bgcolor="#ffff00"><SPAN style="color: #363636;">Iron</SPAN> </TD><TD bgcolor="#ff0000"><SPAN style="color: #363636;">Steel</SPAN> </TD><TD align="right" bgcolor="#ff0000"><SPAN style="color: #363636;">2000</SPAN> </TD></TR><TR align="left" bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Industries</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Work Days</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Actual days worked</SPAN> </TD><TD bgcolor="#00ff00"><SPAN style="color: #363636;">Public Holidays</SPAN> </TD><TD bgcolor="#ffff00"><SPAN style="color: #363636;">Sundays</SPAN> </TD><TD bgcolor="#ff0000"><SPAN style="color: #363636;">Mondays</SPAN> </TD><TD align="right" bgcolor="#808080"><SPAN style="color: #363636;">10</SPAN></TD></TR></TBODY></TABLE><P><BR />I have 3 dimensions- shown here in RAG colours that I want to put a merged heading on top. The 3 dimensions need to stay in 3 seperate columns for purposes of RAG indicators. In the attached model I have put a text object as the heading, but this doesn't work when you put it on a report. The heading then doesn't position correctly.</P><P>Any ideas?</P></BODY></HTML> Tue, 20 Mar 2012 06:00:59 GMT https://community.qlik.com/t5/QlikView/Merged-heading-over-3-dimensions-in-a-pivot-table/m-p/359129#M578869 2012-03-20T06:00:59Z Merged heading over 3 dimensions in a pivot table https://community.qlik.com/t5/QlikView/Merged-heading-over-3-dimensions-in-a-pivot-table/m-p/359130#M578870 <HTML><HEAD></HEAD><BODY><P> What if you just name the dimension Iron "Threshold" and leave other two blank?</P></BODY></HTML> Tue, 20 Mar 2012 08:11:29 GMT https://community.qlik.com/t5/QlikView/Merged-heading-over-3-dimensions-in-a-pivot-table/m-p/359130#M578870 2012-03-20T08:11:29Z Merged heading over 3 dimensions in a pivot table https://community.qlik.com/t5/QlikView/Merged-heading-over-3-dimensions-in-a-pivot-table/m-p/359131#M578871 <HTML><HEAD></HEAD><BODY><P> Mmm, that could work, would of course like it nicely spaced over the three columns, but it doesn't look like it's possible. Thx mbc!</P></BODY></HTML> Tue, 20 Mar 2012 08:19:35 GMT https://community.qlik.com/t5/QlikView/Merged-heading-over-3-dimensions-in-a-pivot-table/m-p/359131#M578871 2012-03-20T08:19:35Z