Document path without filename

[#1]

Hi,

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.

Chris

[sunny_talwar · Accepted 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))

[Peter_Cammaert]

Skip the vDocPath part after the last backslash. DocumentPath() will always return a string with backslashes.

LET vDocPathNoFileName = left('$(vDocPath)', index('$(vDocPath)', '\', -1));

[#4]

thanks alot to everybody. it worked.

[d_koti24]

HI Christian,

May be this helps:

=mid(DocumentPath(),1,len(DocumentPath())-len(DocumentName())-1)

Regards,

kd

[maksimlopatkin]

Hi,

try special variable 'QvWorkPath'