How to get the path of your QlikView document

[#1]

Hello

I wanted to know how I would go about getting the folder/file location of a QlikView document dynamically using the string functions Subfield.

So for example:

My Doc is called TestApp.qvw

The document resides in the following folder: C:\Users\JoeBloggs\TestApp.qvw

I want to be able to use a string function to get the full folder location in which my QlikView file resides in dynamically.

I know there is a solution which I have used but forgotten how is it coded.

Thanks

[quwok]

The function DocumentPath() returns the full path as a string.

[alexandros17]

DocumentPath() returns a string with the full path of the dopcument

[#4]

What if I just want everything before '\TestApp.qvw'? How can I do this dynamically using the string functions?

[#5]

What if I just want everything before '\TestApp.qvw'? How can I do this dynamically using the string functions?

[alexandros17]

this is what you need:

=Mid(DocumentPath(), 1, FindOneOf(DocumentPath(), '\', -1))