Discussion Board for collaboration related to QlikView App Development.
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.
The function DocumentPath() returns the full path as a string.
DocumentPath() returns a string with the full path of the dopcument
What if I just want everything before '\TestApp.qvw'? How can I do this dynamically using the string functions?
this is what you need:
=Mid(DocumentPath(), 1, FindOneOf(DocumentPath(), '\', -1))