topic Re: Relative path in QlikView

Relative path

Tue, 10 Dec 2013 04:58:39 GMT

Hi All,

This is my first post in qlikview community

yesterday some one ask me,what is relative path ?,actually im also don't know could some one explain me this concept

Thanks,

Seeenu

Re: Relative path

Tue, 10 Dec 2013 05:07:40 GMT

Relative Path indicates that the data sources are located in the directory related to the location of qlikview application.

Re: Relative path

jonathandienst — Tue, 10 Dec 2013 05:11:06 GMT

A relative path is the path from the current document (containing the script) to the source data file (eg Excel). For example, if the QVW document is located in C:\QV\Documents and the data file is contained in C:\QV\Data, the relative path for the document would be ..\Data

The advantage of relative paths is that the QVW documents and data files can be moved to another location without changing the script, as long as the relative location is unchanged.

HTH

Jonathan

Re: Relative path

Tue, 10 Dec 2013 05:11:12 GMT

see attachment

see example.

Directory;

LOAD EmpCode,

StartDate,

EndDate,

[No. Of Absent],

FROM

[count issue.xlsx] // indicates, this table save in same directory and same folder of qlikview application.

(ooxml, embedded labels, table is Table2);

//***************************************************************************************************************************************

Directory;

LOAD trid,

pid,

cid

FROM

[..\alk_and mode.xlsx] // indicates, this table save in same directory but not in same folder of qlikview application.

(ooxml, embedded labels, table is Sheet1);

//***************************************************************************************************************************************

Directory;

LOAD da,

date1,

sales

FROM

D:\a.xlsx // indicates, this table save in other directory of qlikview application.

(qvd);

Re: Relative path

Tue, 10 Dec 2013 05:12:54 GMT

Hi Vishwa,

Thanks for your reply

..\..\dev\include\myscript.qvs ,

in this what ...\..\ ,indicates where can i check the path of the data source

Thanks,

Seenu

Re: Relative path

Tue, 10 Dec 2013 05:13:28 GMT

Hi,

I did n't get any Attachments

Thanks,

Seenu