topic Create Label with two variables in QlikView https://community.qlik.com/t5/QlikView/Create-Label-with-two-variables/m-p/377451#M140729 <HTML><HEAD></HEAD><BODY><P>Ok I want a label for an expression to look like this:</P><P></P><P>Y/Y FTE Growth 2010 to 2011 </P><P></P><P>So I have tried several things to get there but am unsuccessful. Can someone give me the exact syntax? Thank you in advance!</P><P></P><P></P><P>= <SPAN style="color: #4d0000; font-size: 8pt;">'Y/Y FTE Growth '</SPAN><SPAN style="font-size: 8pt;"> &amp;</SPAN><STRONG style=": ; color: #008000; font-size: 8pt;">vTwoYearsBack</STRONG><SPAN style="font-size: 8pt;">&nbsp; &amp;</SPAN><STRONG style=": ; color: #008000; font-size: 8pt;">vLastYear </STRONG></P></BODY></HTML> Mon, 13 Aug 2012 15:40:58 GMT 2012-08-13T15:40:58Z Create Label with two variables https://community.qlik.com/t5/QlikView/Create-Label-with-two-variables/m-p/377451#M140729 <HTML><HEAD></HEAD><BODY><P>Ok I want a label for an expression to look like this:</P><P></P><P>Y/Y FTE Growth 2010 to 2011 </P><P></P><P>So I have tried several things to get there but am unsuccessful. Can someone give me the exact syntax? Thank you in advance!</P><P></P><P></P><P>= <SPAN style="color: #4d0000; font-size: 8pt;">'Y/Y FTE Growth '</SPAN><SPAN style="font-size: 8pt;"> &amp;</SPAN><STRONG style=": ; color: #008000; font-size: 8pt;">vTwoYearsBack</STRONG><SPAN style="font-size: 8pt;">&nbsp; &amp;</SPAN><STRONG style=": ; color: #008000; font-size: 8pt;">vLastYear </STRONG></P></BODY></HTML> Mon, 13 Aug 2012 15:40:58 GMT https://community.qlik.com/t5/QlikView/Create-Label-with-two-variables/m-p/377451#M140729 2012-08-13T15:40:58Z Re: Create Label with two variables https://community.qlik.com/t5/QlikView/Create-Label-with-two-variables/m-p/377452#M140730 <HTML><HEAD></HEAD><BODY><P>hi</P><P>&nbsp;&nbsp;&nbsp;&nbsp; </P><P>&nbsp;&nbsp;&nbsp;&nbsp; Try like this,</P><P></P><P>= <SPAN style="font-size: 8pt; color: #4d0000;">'Y/Y FTE Growth '</SPAN><SPAN style="font-size: 8pt;"> &amp;' '&amp;$(</SPAN><STRONG style="font-size: 8pt; color: #008000;">vTwoYearsBack)</STRONG><SPAN style="font-size: 8pt;"> &amp;' '&amp;$(</SPAN><STRONG style="font-size: 8pt; color: #008000;">vLastYear)</STRONG></P><P></P><P></P><P><STRONG style="font-size: 8pt; color: #008000;">Hope it helps<BR /></STRONG></P></BODY></HTML> Mon, 13 Aug 2012 16:11:41 GMT https://community.qlik.com/t5/QlikView/Create-Label-with-two-variables/m-p/377452#M140730 MayilVahanan 2012-08-13T16:11:41Z Re: Create Label with two variables https://community.qlik.com/t5/QlikView/Create-Label-with-two-variables/m-p/377453#M140731 <HTML><HEAD></HEAD><BODY><P>How do I get the&nbsp;&nbsp;&nbsp; 'to'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; this code? </P><P></P><P>Y/Y FTE Growth 2010 to 2011</P></BODY></HTML> Mon, 13 Aug 2012 16:15:55 GMT https://community.qlik.com/t5/QlikView/Create-Label-with-two-variables/m-p/377453#M140731 2012-08-13T16:15:55Z Re: Create Label with two variables https://community.qlik.com/t5/QlikView/Create-Label-with-two-variables/m-p/377454#M140732 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>= <SPAN style="font-size: 8pt; color: #4d0000;">'Y/Y FTE Growth '</SPAN><SPAN style="font-size: 8pt;"> &amp;' '&amp;$(</SPAN><STRONG style="font-size: 8pt; color: #008000;">vTwoYearsBack)</STRONG><SPAN style="font-size: 8pt;"> &amp;'&nbsp; to '&amp;$(</SPAN><STRONG style="font-size: 8pt; color: #008000;">vLastYear)</STRONG></P><P></P><P>Hope it helps</P></BODY></HTML> Mon, 13 Aug 2012 16:22:04 GMT https://community.qlik.com/t5/QlikView/Create-Label-with-two-variables/m-p/377454#M140732 MayilVahanan 2012-08-13T16:22:04Z Re: Create Label with two variables https://community.qlik.com/t5/QlikView/Create-Label-with-two-variables/m-p/377455#M140733 <HTML><HEAD></HEAD><BODY><P>Thank you your answer was very helpful. For some reason the $ didn't work, but the when taken out it works perfect. </P><P></P><P>= <SPAN style="color: #4d0000; font-size: 8pt;">'Y/Y FTE Growth '</SPAN><SPAN style="font-size: 8pt;"> &amp;</SPAN><SPAN style="color: #4d0000; font-size: 8pt;">' '</SPAN><SPAN style="font-size: 8pt;">&amp;(</SPAN><STRONG style=": ; color: #008000; font-size: 8pt;">vTwoYearsBack</STRONG><SPAN style="font-size: 8pt;">) &amp;</SPAN><SPAN style="color: #4d0000; font-size: 8pt;">'&nbsp; to '</SPAN><SPAN style="font-size: 8pt;">&amp;(</SPAN><STRONG style=": ; color: #008000; font-size: 8pt;">vLastYear</STRONG><SPAN style="font-size: 8pt;">) </SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Thank you for you assistance.</SPAN></P><P></P></BODY></HTML> Mon, 13 Aug 2012 16:25:56 GMT https://community.qlik.com/t5/QlikView/Create-Label-with-two-variables/m-p/377455#M140733 2012-08-13T16:25:56Z Re: Create Label with two variables https://community.qlik.com/t5/QlikView/Create-Label-with-two-variables/m-p/377456#M140734 <HTML><HEAD></HEAD><BODY><P>Thank you, Thank you, Thank you!</P></BODY></HTML> Mon, 13 Aug 2012 16:38:59 GMT https://community.qlik.com/t5/QlikView/Create-Label-with-two-variables/m-p/377456#M140734 2012-08-13T16:38:59Z