Discussion Board for collaboration related to Creating Analytics for QlikView.
I am trying to create a Part in the Script, that I can use for all my qvw-files.
Therefore I created two variables for qvw-path and qvw-Name (and I Need them both!)
LET vDocName = DocumentName(); Let vDocPath = DocumentPath ();
The Problem is now, that vDocPath has already the filename in it.
How can I realise, that the DocumentPath is only the DirectoryPath without the Filename
Thanks in advance for you help.
Go to Solution.
May be this helps: Re: How to get the path of your QlikView document
As Suggested by :Alessandro
=Mid(DocumentPath(), 1, FindOneOf(DocumentPath(), '\', -1))
Skip the vDocPath part after the last backslash. DocumentPath() will always return a string with backslashes.
LET vDocPathNoFileName = left('$(vDocPath)', index('$(vDocPath)', '\', -1));
thanks alot to everybody. it worked.
May be this helps:
try special variable 'QvWorkPath'