Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to get the path of your QlikView document

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

5 Replies
quwok
Creator III
Creator III

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

alexandros17

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

Not applicable
Author

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

Not applicable
Author

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))