Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Put both files in same Directory.
Remove relative and absolute path.
Paste your script, we will have look at it
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.
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.
never use absolute paths....
...... unless that is what one needs to use
This should work fine. Let us know if you still have an issue.
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
In that case use vars .....
file env.qs:
LET BASE_DIRECTORY='C:\.....':
$(Must_Include=env.qs);
LOAD .... $(BASE_DIRECTORY)<filename>