Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlikview problem

Hello to everyone. Just to say hi and ask for problem I have.

Recently installed Qlikview and I had to make some report, to import from .xlsx file and everything was ok till I had to send it. I sent .xlsx and .qvw file, but the person I sent it is unable to see my report in .qvw file. He suggested to me to put relative path.... I tried and do that and check box Relative Paths, but when I move .xlsx file to another location my charts are blanc.

Does anyone has solution for this?

17 Replies
Anonymous
Not applicable
Author

Put both files in same Directory.

Remove relative and absolute path.

Not applicable
Author

Paste your script, we will have look at it

Not applicable
Author

My script is:

Directory;

LOAD BI,

     [Ime Prezime],

     Adresa,

     Grad

FROM

GET.xlsx

(ooxml, embedded labels, table is Student);

Path for the .xlsx file is C:\Users\Milos\Documents. When I move it to another location it can not load from .xlsx and charts are blanc.

Anonymous
Not applicable
Author

Try removing the Directory; statement and replace it with a table name like DataTable:

Then state the full path of the xlsx, so you end up with something like:

DataTable:

LOAD BI,

    [Ime Prezime],

    Adresa,

    Grad

FROM

C:\Users\Milos\Documents\GET.xlsx

(ooxml, embedded labels, table is Student);

If you move the xlsx then you will have to change the path in the script.

Note: The character at the end of DataTable: is a colon.

In the QV Desktop Help you can look up the Directory; [final character is a semi colon] statement to see what it does.

Anonymous
Not applicable
Author

never use absolute paths....

Anonymous
Not applicable
Author

...... unless that is what one needs to use

Not applicable
Author

This should work fine. Let us know if you still have an issue.

Not applicable
Author

I've encountered this and I find it just easier to have a "data" folder then any fursther xlsx's can get dropped into there and referenced easier.

ie. c:\qvdata

Anonymous
Not applicable
Author

In that case use vars .....

file env.qs:

LET BASE_DIRECTORY='C:\.....':

$(Must_Include=env.qs);

LOAD .... $(BASE_DIRECTORY)<filename>