Variables in Paths

[hobanwashburne]

I currently use the following in my scripts:

       SET vQVD_Path = '\\asdf\qerty\Qlikview\Development\QVD\TableFiles';

in combination with

     STORE TableName into $(vQVD_Path)\TableName.qvd;

However, when I try:

SET vEnvironment = 'Development';

SET vQVD_Path = '\\asdf\qerty\Qlikview\' & $(vEnvironment) & '\QVD\TableFiles';

my reload fails

Is there a way to make this work?

[richard_pearce6]

Try using LET instead of SET

regards

Richard

QlikCentral.com

[#3]

This is what it returns:

vQVD_Path

"'\\asdf\qerty\Qlikview\' & Development & '\QVD\TableFiles'"

I think it should work if you delete the & like this:

SET vQVD_Path = '\\asdf\qerty\Qlikview\$(vEnvironment)\QVD\TableFiles';

Use the debugger, its a really nice tool!

[hobanwashburne · Accepted solution]

You were both right.

I needed to change "set" to "let" and format the string as Ramiro suggested.

Thank you

[#5]

Hi,

Try to do as follow.

SET vEnvironment = trim('Development');

SET vQVD_Path = '\\asdf\qerty\Qlikview\' & $(vEnvironment) & '\QVD\TableFiles';

It will be helpful..

WanKi,