Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Relative path

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

1 Solution

Accepted Solutions
jonathandienst
Partner - Champion III
Partner - Champion III

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

5 Replies
Not applicable
Author

hi

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

jonathandienst
Partner - Champion III
Partner - Champion III

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable
Author

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

Not applicable
Author

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

Not applicable
Author

Hi,

I did n't get any Attachments

Thanks,

Seenu