Get path of the qlikview file and put it into a variable

[Anonymous]

Hi all,

I want to know if it is possible to get the path of the qvd-file in order to put into a variable.

e.x.:

c:\Test\Projects\test1\test.qvd ==> variable =c:\Test\Projects\test1\

Thank you for helping!

[Anonymous]

Yes, you can use

DocumentPath()

[Anonymous]

Sorry, missed that you meant QVD.

[Anonymous · Accepted solution]

But if you want hardcode the qvd path into a variable as I usually do (so that I only have to set the path in one place)

you just put something like this

SET QVDPath = 'c:\Test\Projects\test1\'
and then call the variable

Load *

From $(QVDPath)\test.qvd (qvd);

[sebastiandperei]

Where do you want to accomplish it?

If you want to do it after the load of these qvd, try:

table:

Load

   field1,

   field2,

   FilePath()  as path

From [c:\Test\Projects\test1\test.qvd] (qvd);

Let variable = Peek ('path');