topic Re: Path of a qlikview document from the mounted folder in QlikView

Path of a qlikview document from the mounted folder

Mon, 06 Apr 2015 14:09:20 GMT

Hi,

Is there a way to get the path of a document from the mounted folder in the reload script? For example if the mounted folder is "MountedFolder" and the qlikview document "Test.qvw" is in a subfolder "SubFolder" of the mounted folder, I would like to have the following return: "MountedFolder/SubFolder/Test.qvw".

Is there a way to achieve that?

Re: Path of a qlikview document from the mounted folder

rohit214 — Mon, 06 Apr 2015 14:21:52 GMT

use =DocumentPath() function.

Re: Path of a qlikview document from the mounted folder

Mon, 06 Apr 2015 14:24:07 GMT

I have tried that but it returns the absolute path of the qlikview document.

Re: Path of a qlikview document from the mounted folder

Mon, 06 Apr 2015 14:29:05 GMT

hi Tad,

Please look into this blog

Folder access

Re: Path of a qlikview document from the mounted folder

Mon, 06 Apr 2015 14:37:41 GMT

It is very interesting but it is not really a solution to my problem.

Re: Path of a qlikview document from the mounted folder

Tue, 07 Apr 2015 06:50:39 GMT

Hello try this expression:

mid(DocumentPath(),index(DocumentPath(),'\',-3)+1)

This should return the document path in you desired format.

Re: Path of a qlikview document from the mounted folder

Tue, 07 Apr 2015 08:06:37 GMT

Thank you for the answer. It works for the example that I gave but It was just an example. In reality, I don't know how many subfolders I have from the mounted folder in QMC to the qlikview document. I have seen that the path I am looking for is exactly the same as the task name of the reload task scheduled in QMC for the qlikview document. So maybe I should rephrase the question:

Is there a way to get the task name of the reload task scheduled in QMC for a qlikview document?

Re: Path of a qlikview document from the mounted folder

Tue, 07 Apr 2015 09:05:16 GMT

Not sure how to retrieve the task name. Are all mounted folders in a common location? If yes, then the expression can be modified to give your desired result.

Re: Path of a qlikview document from the mounted folder

Anonymous — Tue, 07 Apr 2015 09:11:25 GMT

When you get the path to the mounted folder what are you hoping to do with it ?

Re: Path of a qlikview document from the mounted folder

buzzy996 — Tue, 07 Apr 2015 10:10:45 GMT

look at governance dashboard script,hopes u will find.

Re: Path of a qlikview document from the mounted folder

Tue, 07 Apr 2015 10:19:59 GMT

I have scheduled the qlikview document to be reloaded in response to an external event (EDX). To launch the external event, I need the task name.

Re: Path of a qlikview document from the mounted folder

Anonymous — Tue, 07 Apr 2015 10:32:09 GMT

So how would knowing the path to the mounted folder in the script help with initiating an EDX reload ?

Re: Path of a qlikview document from the mounted folder

Thu, 09 Apr 2015 16:09:06 GMT

Thanks. I will take a look as soon as I will install it.

Re: Path of a qlikview document from the mounted folder

Fri, 10 Apr 2015 11:09:11 GMT

Shiva Reddy,

The governance dasboard script is hidden. How can i have access to it?