topic Re: How do I find the current directory? in QlikView

How do I find the current directory?

Tue, 28 Feb 2012 15:09:20 GMT

I created an app in e.g. TestFolder, and then copied it to e.g. LiveFolder. Now, I want to know which folder my app is running in to create different security in Section Access. If I trace the QvWorkPath variable at that point it still shows TestFolder. (I read in the help file that system variables are set at creation time?) Is this usual, and how should I be finding the current directory?

Cheers,

Colin

Re: How do I find the current directory?

jagan — Tue, 28 Feb 2012 15:20:29 GMT

Hi,

Just reload the qlikview file, now you will get the latest path by using the QvWorkPath.

If reload is not possible try File -> Partial Reload option.

Hope this helps you.

Regards,

Jagan.

How do I find the current directory?

swuehl — Tue, 28 Feb 2012 15:55:56 GMT

Or use the QV system function

DocumentPath( )

to get the current doucment path, should work even without reloading.

Hope this helps,

Stefan

How do I find the current directory?

Tue, 28 Feb 2012 17:29:39 GMT

Yes, found a forum post about changing Qlikview to update the variables at the start of the script rather than the end.

Thanks, guys.

Re: How do I find the current directory?

Fri, 10 Feb 2017 16:04:12 GMT

DocumentPath() returns the file path but not the current directory. I could not find an easier way to get the current path (without reloading) so I did the following:

/*Stores Current Working Directory into VarName*/

SUB CurrentWorkingDirectory(VarName)

Let N = SubStringCount(DocumentPath(),'\');

Let $(VarName) = SubField(DocumentPath(),'\',1);

for i = 2 to N

Let $(VarName) = '$($(VarName))\'& SubField(DocumentPath(),'\',$(i));

ENDSUB

Re: How do I find the current directory?

swuehl — Fri, 10 Feb 2017 16:15:13 GMT

=Left(DocumentPath(), Index(DocumentPath(),'\',-1))

Re: How do I find the current directory?

Fri, 10 Feb 2017 17:36:00 GMT

doh! yes that is much better