topic Re: How to concatenate Field value & free Text in QlikView https://community.qlik.com/t5/QlikView/How-to-concatenate-Field-value-free-Text/m-p/791182#M279756 <HTML><HEAD></HEAD><BODY><P><IMG alt="146850.png" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/74263_146850.png" style="height: auto;" /></P></BODY></HTML> Sat, 27 Dec 2014 12:48:00 GMT anbu1984 2014-12-27T12:48:00Z How to concatenate Field value & free Text https://community.qlik.com/t5/QlikView/How-to-concatenate-Field-value-free-Text/m-p/791180#M279754 <HTML><HEAD></HEAD><BODY><P> In pivot table i want to show 'Total of Pqr &amp; Total of Xyz'.</P><P>I have writtent an expression</P><P> <SPAN style="font-size: 10pt;"><SPAN style="font-size: 10pt;"><SPAN style="color: #0000ff; font-size: 10pt;">if</SPAN>(<SPAN style="color: #0000ff; font-size: 10pt;">Dimensionality</SPAN>()=0, 'Total of ' &amp; <SPAN style="color: #800000; font-size: 10pt;">Leader2</SPAN>) </SPAN> indicated in red mark below screenshot.</SPAN></P><P><SPAN style="font-size: 10pt;">I want to concatenate '</SPAN><SPAN style="font-size: 10pt;"><SPAN style="font-size: 10pt;">Total of </SPAN><SPAN style="font-size: 10pt;">' with column</SPAN></SPAN><SPAN><SPAN style="font-size: 10pt;"> </SPAN><SPAN style="color: #800000; font-size: 10pt;"><SPAN style="font-size: 10pt;">Leader2. Please help me on this?</SPAN></SPAN></SPAN></P><P>Also sample Qlikview file is attached for reference.</P><P><IMG alt="123d.png" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/74267_123d.png" style="width: 620px; height: 496px;" /></P></BODY></HTML> Sat, 27 Dec 2014 10:43:14 GMT https://community.qlik.com/t5/QlikView/How-to-concatenate-Field-value-free-Text/m-p/791180#M279754 2014-12-27T10:43:14Z Re: How to concatenate Field value & free Text https://community.qlik.com/t5/QlikView/How-to-concatenate-Field-value-free-Text/m-p/791181#M279755 <HTML><HEAD></HEAD><BODY><P>You cannot customize the labels for the subtotals. All the subtotal labels in a dimension will get the same text value. You cannot use dimension values for subtotal labels. Maybe you can use the approach from this discussion as an alternative: <A href="https://community.qlik.com/thread/66239">Custom Labels in Pivot Table</A></P></BODY></HTML> Sat, 27 Dec 2014 11:05:14 GMT https://community.qlik.com/t5/QlikView/How-to-concatenate-Field-value-free-Text/m-p/791181#M279755 Gysbert_Wassenaar 2014-12-27T11:05:14Z Re: How to concatenate Field value & free Text https://community.qlik.com/t5/QlikView/How-to-concatenate-Field-value-free-Text/m-p/791182#M279756 <HTML><HEAD></HEAD><BODY><P><IMG alt="146850.png" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/74263_146850.png" style="height: auto;" /></P></BODY></HTML> Sat, 27 Dec 2014 12:48:00 GMT https://community.qlik.com/t5/QlikView/How-to-concatenate-Field-value-free-Text/m-p/791182#M279756 anbu1984 2014-12-27T12:48:00Z