topic Variables in Paths in QlikView

Variables in Paths

hobanwashburne — Tue, 23 Sep 2014 14:13:53 GMT

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 — Tue, 23 Sep 2014 14:18:23 GMT

Try using LET instead of SET

regards

Richard

QlikCentral.com

Tue, 23 Sep 2014 14:21:15 GMT

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 — Tue, 23 Sep 2014 14:49:05 GMT

You were both right.

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

Thank you

Tue, 23 Sep 2014 14:53:45 GMT

Hi,

Try to do as follow.

SET vEnvironment = trim('Development');

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

It will be helpful..

WanKi,