Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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
bestofwest
Contributor II

Re: Qlikview problem

Put both files in same Directory.

Remove relative and absolute path.

Not applicable

Re: Qlikview problem

Paste your script, we will have look at it

Not applicable

Re: Qlikview problem

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.

Re: Qlikview problem

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.

bestofwest
Contributor II

Re: Qlikview problem

never use absolute paths....

Re: Qlikview problem

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

Not applicable

Re: Qlikview problem

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

Not applicable

Re: Qlikview problem

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

bestofwest
Contributor II

Re: Qlikview problem

In that case use vars .....

file env.qs:

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

$(Must_Include=env.qs);

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

Community Browser