Relative Path

[manoranjan_d]

Relative Path can u any one explain

[Digvijay_Singh]

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.

[sunny_talwar]

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

[stevedark]

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

[manoranjan_d]

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

[sunny_talwar]

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

[#7]

Sunny,

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

[stevedark]

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