topic Re: Concatenate Two string variables??? in QlikView

Concatenate Two string variables???

soha1902 — Tue, 24 Mar 2015 08:59:50 GMT

Hi All,

I am using two variables which contains string values like

vFirst = 'A','B','C'

vSecond='D','E'

Now I want to concatenate these values into one variable (as vCombine ='A','B','C','D','E' ), for this I am using below statement in script:

Let vCombine = '$(vFirst)' & ',' & '$(vSecond)'

But it is showing Script Error message. Can any one help me.

Thanks in advance.....

Tue, 24 Mar 2015 09:07:32 GMT

Use set instead.

set vOne = 'A';

set vTwo = 'B';

set vThree = $(vOne) & $(vTwo);

etc

Tue, 24 Mar 2015 09:26:13 GMT

Hi,

You can try this script.

SET vFirst = 'A','B','C';

SET vSecond='D','E';

SET vCombine = $(vFirst),$(vSecond);

Anonymous — Tue, 24 Mar 2015 09:36:06 GMT

check out the attached test app

set vFirst = 'A','B','C';

set vSecond='D','E';

LET vcombine=vFirst&','&vSecond;

Gabriel — Tue, 24 Mar 2015 10:36:21 GMT

Hi,

Try

=vFirst &','& vSecond

and click ok

Tue, 24 Mar 2015 14:08:09 GMT

please try this expression

set vFirst = 'A','B','C';

set vSecond='D','E';

LET vcombine=vFirst&','&vSecond;