topic Re: Dynamic Label (Pivot) in QlikView https://community.qlik.com/t5/QlikView/Dynamic-Label-Pivot/m-p/784862#M533491 <HTML><HEAD></HEAD><BODY><P>In the caption, I would probably use the following expression:</P><P></P><P><SPAN style="font-size: 10pt;">=<SPAN style="color: #0000ff;">GetFieldSelections</SPAN>(<SPAN style="color: #800000;">Mth</SPAN>) </SPAN></P></BODY></HTML> Fri, 27 Mar 2015 16:06:30 GMT c_gilbert 2015-03-27T16:06:30Z Dynamic Label (Pivot) https://community.qlik.com/t5/QlikView/Dynamic-Label-Pivot/m-p/784861#M533490 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a table below loaded:</P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="320"><TBODY><TR><TD height="20" width="64">Version</TD><TD width="64">Mth</TD><TD width="64">Cust</TD><TD width="64">Value</TD><TD width="64">Actuals</TD></TR><TR><TD align="right" height="20">1</TD><TD>Jan</TD><TD>a</TD><TD align="right">232</TD><TD align="right">543</TD></TR><TR><TD align="right" height="20">1</TD><TD>Feb</TD><TD>a</TD><TD align="right">232</TD><TD align="right">434</TD></TR><TR><TD align="right" height="20">2</TD><TD>Mar</TD><TD>a</TD><TD align="right">54</TD><TD align="right">32</TD></TR><TR><TD align="right" height="20">2</TD><TD>Apr</TD><TD>a</TD><TD align="right">6</TD><TD align="right">78</TD></TR><TR><TD align="right" height="20">2</TD><TD>May</TD><TD>a</TD><TD align="right">7</TD><TD align="right"><P>23</P><P></P></TD></TR></TBODY></TABLE><P></P><P>What I want to show is:</P><P>1. The label for the 'Value' of the pivot table be change to Value &lt;latest version of the month&gt;</P><P><IMG alt="" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/81766_pastedImage_1.png" style="max-width: 1200px; max-height: 900px;" /></P><P>2. So above, I selected Feb and Mar, should output: Value (1) | Value (2)</P><P>Is this possible?</P><P></P><P>Thanks all</P></BODY></HTML> Wed, 25 Mar 2015 02:52:52 GMT https://community.qlik.com/t5/QlikView/Dynamic-Label-Pivot/m-p/784861#M533490 2015-03-25T02:52:52Z Re: Dynamic Label (Pivot) https://community.qlik.com/t5/QlikView/Dynamic-Label-Pivot/m-p/784862#M533491 <HTML><HEAD></HEAD><BODY><P>In the caption, I would probably use the following expression:</P><P></P><P><SPAN style="font-size: 10pt;">=<SPAN style="color: #0000ff;">GetFieldSelections</SPAN>(<SPAN style="color: #800000;">Mth</SPAN>) </SPAN></P></BODY></HTML> Fri, 27 Mar 2015 16:06:30 GMT https://community.qlik.com/t5/QlikView/Dynamic-Label-Pivot/m-p/784862#M533491 c_gilbert 2015-03-27T16:06:30Z