Concat string variable

Fri, 10 Aug 2012 20:55:04 GMT

I'd like to have my user enter a path as input variable. e.g strUserpath = 'G:\Bob\May' Then I want to load a list of company and file locations e.g.

Company Location

ABC \ABC\Broker\1234412

ABC \ABC\Brokers\123413

XYZ \Sales\Forecasts\12345

DEF \Reports\Activity\113414

and create a straight table with a new column whose expression is:

$(strUserpath) & Location

But this doesn't work; it doesn't seem to recognize strUserpath as a string. The column just shows the Location.

I tried =concat($(strUserpath),Location)) but that just returned a blank column.

Once again, the documentation is no help,

When using a variable for text replacement in the script or in an expression,
the syntax $(variablename ) is used. $(variablename) expands to the value in variablename.

because it sure doesn't seem to be doing that for me!

Re: Concat string variable

swuehl — Fri, 10 Aug 2012 21:54:41 GMT

Hi kevinbmsr,

could be, that your variable is not recognized as string when expanded.

Try enclosing your variable within single quotes:

='$(strUserpath)' & Location

Re: Concat string variable

senpradip007 — Sat, 11 Aug 2012 02:14:11 GMT

Hi kevinbmsr,

you can try with the expression ='$(strUserpath)' & Location

Hope it helps you

Pradip

topic Re: Concat string variable in QlikView

Concat string variable

Re: Concat string variable

Re: Concat string variable