topic Re: Relative Path in QlikView

Relative Path

manoranjan_d — Sat, 01 Aug 2015 18:55:49 GMT

Relative Path can u any one explain

Re: Relative Path

Digvijay_Singh — Sat, 01 Aug 2015 19:11:57 GMT

From Ref Manual -

Relative Paths - If this setting is enabled, QlikView will use relative paths instead of absolute paths in the script. Relative paths are normally required when a document is to be moved between different computers. This setting is also available in the User Preferences dialog. If it is changed there, it will also be changed in the Edit Script and Edit Hidden Script dialogs.

Re: Relative Path

sunny_talwar — Sat, 01 Aug 2015 19:47:24 GMT

There is absolute path and there is relative path. Absolute path will list the complete path from where the file is sitting. For example this is the folder structure:

P drive
- All_Applications
  - ABC_Application
    - ABC.qvw (your application)
    - Source_Data
      - Source_File.xlsx (your data source)

Absolute path when you pull data from it would be: P\All_Applications\ABC_Application\Source_Data\Source_File.xlsx

Relative Path would be:

Source_Data\Source_File.xlsx

Now the benefit of using a relative path is that when you move your application to the server your relative path will still work (if you don't change the folder structure and copy paste everything under All_Application), where as if you use Absolute path the path will not work unless everything starting with P drive has the exact same name.

I hope this will explain everything you need for Relative and Absolute path.

Best,

Sunny

Re: Relative Path

stevedark — Sat, 01 Aug 2015 21:18:56 GMT

Hi,

It is worth setting out a folder structure similar to what I outline in this post:

http://www.quickintelligence.co.uk/qlikview-folder-structures/‌

If you do have this kind of structure, you may have QVDs in a folder such as:

d:\QVDocs\QVDs\MyData.qvd

And your applications in a folder like this:

d:\QVDocs\Published\Finaance\MyApp.qvd

To open the MyData QVD from the MyApp application you could use the following relative path:

..\..\QVDs\MyData.qvd

Hope that makes sense.

Cheers,

Steve

Re: Relative Path

manoranjan_d — Thu, 06 Aug 2015 21:29:33 GMT

instead of using both we can simply use ..\data and ..\qvd that will be better ?

Re: Relative Path

sunny_talwar — Fri, 07 Aug 2015 01:34:20 GMT

instead of using both we can simply use ..\data and ..\qvd that will be better ?

this is relative path. To my knowledge, there are only 2 methods only.

HTH

Best,

Sunny

Re: Relative Path

Tue, 01 Sep 2015 13:40:08 GMT

Sunny,

How we should create the relative path..?? can you please explain me..???

Re: Relative Path

stevedark — Tue, 01 Sep 2015 19:40:57 GMT

My response below, and the referenced blog post give precise instructions.

Simply save the .qvw file in one folder, eg:

c:\qv\apps\MyQVW.qvw

And your data in another that is positioned relatively, eg:

c:\qv\data\MyData.qvd

You can then reference the data file like this:

FROM ..\data\MyData.qvd (qvd);

The advantage of this is that you can copy the entire qv folder to somewhere else, e.g. x:\somefolder\qv and the load script will still work fine, as it is not referencing a specific path.

I would suggest that it is best practice to never reference a specific location and all paths should be relative.

Hope that helps.

Steve