Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
atafsson
Creator
Creator

Concatenate variable-value

Hi,

I'd like to concatenate the value from a variable into a table. How do I do??

I tried this, but it does'nt work:

LET Domain1 = 'COMPANYNAME';

LET User1 = 'USERNAME1';

TAB:

LOAD * INLINE [

    domain2, user2

    DOMÄNTEST, ANVTEST
]
;

Concatenate (TAB)
load '$(Domain1)' as domain2,
         '$(User1)' as
user2
;

1 Solution

Accepted Solutions
MayilVahanan

Hi

Try like this

LET Domain1 = 'COMPANYNAME';

LET User1 = 'USERNAME1';

TAB:

         LOAD * INLINE [

    domain2, user2

    DOMÄNTEST, ANVTEST

];

load '$(Domain1)' as domain2,

         '$(User1)' as user2 Resident TAB;

Hope it helps

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

View solution in original post

5 Replies
MayilVahanan

Hi

Try like this

LET Domain1 = 'COMPANYNAME';

LET User1 = 'USERNAME1';

TAB:

         LOAD * INLINE [

    domain2, user2

    DOMÄNTEST, ANVTEST

];

load '$(Domain1)' as domain2,

         '$(User1)' as user2 Resident TAB;

Hope it helps

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

Thank you Mayil!

Anonymous
Not applicable

i have same requirement but bit different. i want field values of list boxes changes upon selection of different buttons (using variable)

the reason why i need this is i'm conditionally enabling the expresions based of list box fields

plz find the attached sample application

Thanks in Advance

have a good day

MayilVahanan

HI

Are you want something like attached file?

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

thanks got it