topic Re: Qlikview script relative path syntax in App Development

Qlikview script relative path syntax

Bo_PT — Thu, 11 Jul 2024 19:34:38 GMT

Hi, On our Qlikview server, the source_documents folder structure is something like this:

- Source_documents

- Project_A

- 1_resource

- 2_include

- 3_QVDGenerator

- 4_QVD

- 5_Application

We have a qvw which is located under the '3_QVDGenerator' subfolder and we have a DBinfo.qvs located under the '2_include' subfolder. The qvw has this line in its script:

$(Must_Include=' \..\..\2_include\DBinfo.qvs');

The qvw works well but I don't understand why. I know syntax like '..\' will go up to the 'Project_A' parent folder, right? What does '\..\..\' do here?

Thanks

Re: Qlikview script relative path syntax

marksouzacosta — Fri, 12 Jul 2024 03:57:37 GMT

The \ at the beginning means the root directory.
So if I do something like $(Must_Include='\AnotherInclude.qvs); I'm telling Qlik to go to the root directory and find the AnotherInclude.qvs file.

I tried to simulate the $(Must_Include=' \..\..\2_include\DBinfo.qvs'); exactly like you did and in my Windows 11 it did not work at all. Do you have a DIRECTORY statement somewhere in your Load Script or any other Include Statement?

Re: Qlikview script relative path syntax

Bo_PT — Fri, 12 Jul 2024 11:26:14 GMT

HI Marksouzacosta Thanks for your reply. Do you mean the root directory of the drive (like D:\ drive) or the root directory of QDS (Soource_Documents)?

Re: Qlikview script relative path syntax

Bo_PT — Fri, 12 Jul 2024 12:00:26 GMT

I just found there is a mistake in my original post. There is another subfolder level in our folder structure. It is actually like this:

- 😧 \Source_documents
- Department_A
- Project_A
- 1_resource
   - 2_include
   - 3_QVDGenerator
   - 4_QVD
   - 5_Application

So if \ goes up to the D:\Source_documents folder, each ..\ goes one level down. Then it might explain. Is it how it works?

Re: Qlikview script relative path syntax

marksouzacosta — Fri, 12 Jul 2024 13:04:59 GMT

The Drive, directory D:\

Re: Qlikview script relative path syntax

marksouzacosta — Fri, 12 Jul 2024 13:10:48 GMT

I tried that too, adding another level but in my case, it hasn't worked too. I think something else is affecting the folder. Can you please share your QVW or your Load Script?

Re: Qlikview script relative path syntax

Bo_PT — Fri, 12 Jul 2024 14:34:41 GMT

folder.png shows the folder structure on Qlikview server.
script.png shows the Qlikview app (qvf) script.

Re: Qlikview script relative path syntax

Bo_PT — Fri, 12 Jul 2024 14:56:31 GMT

I made 3 simplified files. See attachments: FolderTest.qvf, DBCredential.qvs, ExternalDataPath.txt.

Re: Qlikview script relative path syntax

marksouzacosta — Fri, 12 Jul 2024 15:04:33 GMT

That is funny...
I was using Must_Include without space before the first \:
$(Must_Include='\..\..\2_include\DBInfo.qvs');

Now I see you have a space before. I have added the space and it worked:
$(Must_Include=' \..\..\2_include\DBInfo.qvs');

The first one renders as:
$(MUST_INCLUDE= ***. E:\..\..\2_include\DBInfo.qvs file not found.

My guess is, space + \..\ just gets ignored by Qlik. It does not mean anything. It is - awkwardly - the same as: $(Must_Include='..\2_include\DBInfo.qvs');

To prove my point, I moved the QVD Generator a another subfolder and I have used the following and it worked:
$(Must_Include=' \..\..\..\2_include\DBInfo.qvs');

So, \..\ is ignored and Qlik moves up two folder levels to find the DBinfo.qvs.

At the end I think you just found a bug. I would recommend removing the extras \..\ and keep as:
$(Must_Include='..\2_include\DBInfo.qvs');