topic How to set header for combination of two or more columns in pivot table in QlikView https://community.qlik.com/t5/QlikView/How-to-set-header-for-combination-of-two-or-more-columns-in/m-p/386578#M144386 <HTML><HEAD></HEAD><BODY><P><SPAN class="hps">How to set</SPAN> <SPAN class="hps">header</SPAN> <SPAN class="hps">for</SPAN> <SPAN class="hps">combination</SPAN> <SPAN class="hps">of</SPAN> <SPAN class="hps">two</SPAN> <SPAN class="hps">or more</SPAN> <SPAN class="hps">columns</SPAN> <SPAN class="hps">in</SPAN> <SPAN class="hps">pivot table</SPAN></P><P></P><P><SPAN class="hps">eg</SPAN></P><P></P><P><SPAN class="hps">&nbsp;&nbsp; Weekly&nbsp; S</SPAN><SPAN class="hps">ales&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN class="hps">Monthly</SPAN> S<SPAN class="hps">ales</SPAN></P><P><SPAN class="hps">---------------------------------------------------</SPAN></P><P><SPAN class="hps">&nbsp; Tons&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN class="hps">Amount&nbsp;&nbsp; </SPAN><SPAN class="hps">&nbsp;&nbsp;&nbsp; Tons</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="hps">Amount</SPAN></P></BODY></HTML> Wed, 30 Jan 2013 19:35:02 GMT 2013-01-30T19:35:02Z How to set header for combination of two or more columns in pivot table https://community.qlik.com/t5/QlikView/How-to-set-header-for-combination-of-two-or-more-columns-in/m-p/386578#M144386 <HTML><HEAD></HEAD><BODY><P><SPAN class="hps">How to set</SPAN> <SPAN class="hps">header</SPAN> <SPAN class="hps">for</SPAN> <SPAN class="hps">combination</SPAN> <SPAN class="hps">of</SPAN> <SPAN class="hps">two</SPAN> <SPAN class="hps">or more</SPAN> <SPAN class="hps">columns</SPAN> <SPAN class="hps">in</SPAN> <SPAN class="hps">pivot table</SPAN></P><P></P><P><SPAN class="hps">eg</SPAN></P><P></P><P><SPAN class="hps">&nbsp;&nbsp; Weekly&nbsp; S</SPAN><SPAN class="hps">ales&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN class="hps">Monthly</SPAN> S<SPAN class="hps">ales</SPAN></P><P><SPAN class="hps">---------------------------------------------------</SPAN></P><P><SPAN class="hps">&nbsp; Tons&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN class="hps">Amount&nbsp;&nbsp; </SPAN><SPAN class="hps">&nbsp;&nbsp;&nbsp; Tons</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="hps">Amount</SPAN></P></BODY></HTML> Wed, 30 Jan 2013 19:35:02 GMT https://community.qlik.com/t5/QlikView/How-to-set-header-for-combination-of-two-or-more-columns-in/m-p/386578#M144386 2013-01-30T19:35:02Z Re: How to set header for combination of two or more columns in pivot table https://community.qlik.com/t5/QlikView/How-to-set-header-for-combination-of-two-or-more-columns-in/m-p/386579#M144387 <HTML><HEAD></HEAD><BODY><P>Either create a dimension with the values Weekly Sales and Monthly Sales or use text boxes as labels. See attached example. </P></BODY></HTML> Wed, 30 Jan 2013 20:12:39 GMT https://community.qlik.com/t5/QlikView/How-to-set-header-for-combination-of-two-or-more-columns-in/m-p/386579#M144387 Gysbert_Wassenaar 2013-01-30T20:12:39Z Re: How to set header for combination of two or more columns in pivot table https://community.qlik.com/t5/QlikView/How-to-set-header-for-combination-of-two-or-more-columns-in/m-p/386580#M144388 <HTML><HEAD></HEAD><BODY><P>ok.</P><P></P><P><SPAN class="hps">thanks,</SPAN> Gysbert</P></BODY></HTML> Wed, 30 Jan 2013 20:16:24 GMT https://community.qlik.com/t5/QlikView/How-to-set-header-for-combination-of-two-or-more-columns-in/m-p/386580#M144388 2013-01-30T20:16:24Z Re: How to set header for combination of two or more columns in pivot table https://community.qlik.com/t5/QlikView/How-to-set-header-for-combination-of-two-or-more-columns-in/m-p/386581#M144389 <HTML><HEAD></HEAD><BODY><P><SPAN class="hps">But what would be</SPAN> <SPAN class="hps">the solution for</SPAN> <SPAN class="hps">many</SPAN> <SPAN class="hps">columns</SPAN> <SPAN class="hps">pivot tables</SPAN>?</P></BODY></HTML> Wed, 30 Jan 2013 20:24:09 GMT https://community.qlik.com/t5/QlikView/How-to-set-header-for-combination-of-two-or-more-columns-in/m-p/386581#M144389 2013-01-30T20:24:09Z