topic Re: Relative path in QlikView

Relative path

Thu, 30 Jan 2014 14:26:51 GMT

hi,

can any body please let me know what is relative path with example.

regards

Mahesh T

Re: Relative path

Anonymous — Thu, 30 Jan 2014 14:29:56 GMT

Mahesh

This script line sets a variable to relative folder path.

let vFolderConfig = '..\..\Config\' ;

Later in the script I load a spreadsheet using a dollar expansion of the variable.

LOAD

USAGE,

APPLICATION,

VALUE,

VARIABLE

FROM $(vFolderConfig)Variables.xlsx (ooxml, embedded labels, table is Variables)

WHERE APPLICATION = 'DASH' ;

;

Best Regards, Bill

Re: Relative path

maxgro — Thu, 30 Jan 2014 14:51:34 GMT

path relative to what?

path is relative to the .qvw file.

Re: Relative path

ThornOfCrowns — Thu, 30 Jan 2014 14:53:28 GMT

The part of Bill's post to remember is the '..\..\' part which means look down the releative path from where you are at that point.

A relative path is a way to specify the location of a directory relative to another directory. For example, suppose your data is in C:\Sample\Data and your dashboard is in C:\Sample\Dashboards. The absolute path for the data would be C:\Sample\Data. The relative path from C:\Sample\Dashboards to C:\Sample\Data would be ..\Data.