Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Create Label with two variables

Ok I want a label for an expression to look like this:

Y/Y FTE Growth 2010 to 2011

So I have tried several things to get there but am unsuccessful. Can someone give me the exact syntax? Thank you in advance!

= 'Y/Y FTE Growth ' &vTwoYearsBack  &vLastYear

1 Solution

Accepted Solutions
Not applicable
Author

Thank you your answer was very helpful. For some reason the $ didn't work, but the when taken out it works perfect.

= 'Y/Y FTE Growth ' &' '&(vTwoYearsBack) &'  to '&(vLastYear)

Thank you for you assistance.

View solution in original post

5 Replies
MayilVahanan

hi

    

     Try like this,

= 'Y/Y FTE Growth ' &' '&$(vTwoYearsBack) &' '&$(vLastYear)

Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

How do I get the    'to'        this code?

Y/Y FTE Growth 2010 to 2011

MayilVahanan

Hi

= 'Y/Y FTE Growth ' &' '&$(vTwoYearsBack) &'  to '&$(vLastYear)

Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

Thank you your answer was very helpful. For some reason the $ didn't work, but the when taken out it works perfect.

= 'Y/Y FTE Growth ' &' '&(vTwoYearsBack) &'  to '&(vLastYear)

Thank you for you assistance.

Not applicable
Author

Thank you, Thank you, Thank you!