Relative path

[#1]

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

[#2]

hi

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

[jonathandienst · Accepted solution]

Hi

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

[#4]

hi

see attachment

see example.

Directory;

LOAD EmpCode,

     StartDate,

     EndDate,

     [No. Of Absent],

     E,

     F,

     G,

     H,

     I,

     J,

     K,

     L

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);

[#5]

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

[#6]

Hi,

I did n't get any Attachments

Thanks,

Seenu