Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Document path without filename

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

1 Solution

Accepted Solutions

Re: Document path without filename

May be this helps: Re: How to get the path of your QlikView document

As Suggested by :Alessandro

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

5 Replies

Re: Document path without filename

May be this helps: Re: How to get the path of your QlikView document

As Suggested by :Alessandro

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

Re: Document path without filename

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

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

Not applicable

Re: Document path without filename

thanks alot to everybody. it worked.

d_koti24
Contributor

Re: Document path without filename

HI Christian,

May be this helps:

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

Regards,

kd

maksimlopatkin
New Contributor

Re: Document path without filename

Hi,

try special variable 'QvWorkPath'

 

Community Browser