topic Re: using variable in path in QlikView

using variable in path

Mon, 28 Jul 2014 06:00:12 GMT

I've got

Load...

FROM $(vQvdPath) & '\my_QVD_Data_File.QVD'

my variable vQvdPath has: QVD\

I want to be able to change my vQvdPath easily, that's why I used this variable. What am I doing wrong?

jonathandienst — Mon, 28 Jul 2014 06:07:21 GMT

FROM [$(vQvdPath)\my_QVD_Data_File.QVD] (qvd)

HTH

Jonathan

Mon, 28 Jul 2014 07:54:27 GMT

Thanks, Jonathan, unfortunately, it doesn't like the square brackets. I've also tried '[' & $(vQvdPath).

The error is:

Cannot open file 'C:\.....' The filename, directory name, or volume label syntax is incorrect.

Mon, 28 Jul 2014 08:02:44 GMT

Use what Jonathan said just without the \

So:

FROM [$(vQvdPath)my_QVD_Data_File.QVD] (qvd)

as your path has the \ already

Joe

Mon, 28 Jul 2014 08:04:46 GMT

I found the answer.

It looks like you can't just add a variable to the Variables list. (ie. in Variables list, click "add)

But you can do this: SET vQvdPath = QVD\; <-- it is then added to the Variables list. Then it's happy.

I'm not sure if it's a bug.

Mon, 28 Jul 2014 08:10:41 GMT

no you can't just add like that and no it's not a bug, only variables created in the script can be used in the script.

glad you found the answer

Joe

Mon, 28 Jul 2014 08:16:19 GMT

Thanks JoeSimmons for clarifying . I hadn't realised that.