topic Re: Qlikview problem in QlikView

Qlikview problem

Mon, 23 Feb 2015 16:58:21 GMT

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?

Re: Qlikview problem

Anonymous — Tue, 24 Feb 2015 02:17:54 GMT

Put both files in same Directory.

Remove relative and absolute path.

Re: Qlikview problem

Tue, 24 Feb 2015 02:22:54 GMT

Paste your script, we will have look at it

Re: Qlikview problem

Tue, 24 Feb 2015 09:12:19 GMT

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

Anonymous — Tue, 24 Feb 2015 19:28:59 GMT

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.

Re: Qlikview problem

Anonymous — Tue, 24 Feb 2015 21:20:21 GMT

never use absolute paths....

Re: Qlikview problem

Anonymous — Tue, 24 Feb 2015 21:23:00 GMT

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

Re: Qlikview problem

Tue, 24 Feb 2015 21:24:36 GMT

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

Re: Qlikview problem

Tue, 24 Feb 2015 21:27:36 GMT

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

Re: Qlikview problem

Anonymous — Tue, 24 Feb 2015 21:40:12 GMT

In that case use vars .....

file env.qs:

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

$(Must_Include=env.qs);

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

Re: Qlikview problem

oknotsen — Tue, 24 Feb 2015 21:57:29 GMT

Okay, so now we put that env.qs on a file server so all my different publisher nodes can use it, because face it: We need a heavy clustered environment to solve this .

The topic at hand is that we have a local client (maybe just a personal edition) in which someone new to QlikView just wants to load 1 XLS file and want to give that simple script to someone else. Lets not bother him with more technical stuff than needed.

So, to the OP:

Just put the XLS file and the QVW in the same folder and remove anything that looks like a path. Tell your friend / colleague to do the same; problem solved.

DataTable:

LOAD BI,

[Ime Prezime],

Adresa,

Grad

FROM GET.xlsx

(ooxml, embedded labels, table is Student);

Hope that solves your problem. If not, let us know what you run into and I am sure we can get you where you want to go.

Re: Qlikview problem

Anonymous — Tue, 24 Feb 2015 22:03:08 GMT

In case remove env.qs

and put only:

$(Include=env.qs);

simple....

Of course I don't use Absolute Paths....

Re: Qlikview problem

Wed, 25 Feb 2015 07:43:54 GMT

I have to send this so that's why I have to use absolute path, and he specified to me that this 2 files must be in separate folders. This didn't help me because when I move .xlsx to another location charts are empty.

I use QlikView version 11.20.12742.0 SR10 x64

Thank you all for reply

Re: Qlikview problem

mukesh24 — Wed, 25 Feb 2015 07:46:22 GMT

can u please provide u r qvw file?

Re: Qlikview problem

oknotsen — Wed, 25 Feb 2015 07:48:19 GMT

Situation is this:

QlikView needs to know where the file is, be it via a relative path or via an absolute path.

If QlikView can find the file there, it will load during the script.

IF you then move it to another location, it will again not work as the script cant find it in the location it expect is, so you will have to change the script to point it at the right location again.

So:

Both you, the developer, and the client need to put the files in the same folder OR have the same folder structure so your script works in both your and his situation.

Re: Qlikview problem

oknotsen — Wed, 25 Feb 2015 07:49:53 GMT

No need for that. He already supplied the code he uses in the script.

Re: Qlikview problem

Wed, 25 Feb 2015 09:08:20 GMT

Thank you all. I understood and did that what you suggested to me.

Re: Qlikview problem

Wed, 25 Feb 2015 09:17:18 GMT

set a variable

SET vpath ='your file path\' ;

Directory;

LOAD BI,

[Ime Prezime],

Adresa,

Grad

FROM

$(vpath)GET.xlsx.

(ooxml, embedded labels, table is Student);

then tell ur partner to same path...... SET vpath ='your file path\' ;