Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
hobanwashburne
Creator
Creator

Variables in Paths

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?

1 Solution

Accepted Solutions
hobanwashburne
Creator
Creator
Author

You were both right.

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

Thank you

View solution in original post

4 Replies
richard_pearce6
Luminary Alumni
Luminary Alumni

Try using LET instead of SET

regards

Richard

QlikCentral.com

Not applicable

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
Creator
Creator
Author

You were both right.

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

Thank you

Not applicable

Hi,

Try to do as follow.

SET vEnvironment = trim('Development');

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

It will be helpful..

WanKi,