Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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!