topic Re: loading problen in QlikView

loading problem

Fri, 12 Sep 2014 15:06:15 GMT

hi QV,

How to load data source like this with out folder path

LOAD Date,

Year,

Sales

FROM

Data.xlsx

(ooxml, embedded labels, table is [Dummy Sales]);

-lohi

Re: loading problen

ecolomer — Fri, 12 Sep 2014 15:08:51 GMT

You can use the complet path to access file.

By the wizard you can try

Re: loading problen

Fri, 12 Sep 2014 15:10:55 GMT

hi , thaxks for rply

i cant understand what you are saying can plz elaborate

-lohi

Re: loading problen

Fri, 12 Sep 2014 15:13:40 GMT

If you save your QV Document within the same folder like your Datasource you can Skip the path.

Another way is to set your Directory in the beginning of your script.

Re: Re: loading problen

MK_QSL — Fri, 12 Sep 2014 15:14:39 GMT

Untick Relative Path.....remove all script lines and load again..

Re: loading problen

Fri, 12 Sep 2014 15:15:34 GMT

hi patrick,

can you plz share the screen shot let me knw how plz

-lohi

Re: loading problen

MK_QSL — Fri, 12 Sep 2014 15:20:41 GMT

Something like below

Set vPath = 'C:\Users\ABC\Desktop';

LOAD Customer,

Sales

FROM

$(vPath)\Sales.qvd

(qvd);

2nd:

If you have

Sales.qvd and Your QlikView Application saved in same path...

i.e. C:\Users\ABC\Desktop

Then you can directly load as

LOAD Customer,

Sales

FROM

Sales.qvd

(qvd);

Re: loading problen

ecolomer — Fri, 12 Sep 2014 15:21:25 GMT

yes, of course.

when you select a new flat file, you must specify the path by which you access the file.

sorry because i'm spanish and the QV are in spanish

RED = LAN

Fichero Plano = Plain File .... for EXCEL FILE

Re: loading problen

Fri, 12 Sep 2014 15:21:27 GMT

I am doing it like this:

SET Datasource = 'X:\Data\Qlik View\Dummy\'; //just a dummypath

//now i can load my Tables like this

dummytable:

Load

test,

test2

FROM $(Datenquelle)\dummydata.qvo (ansi, txt, delimiter is '\t', embedded labels);

Re: loading problen

Fri, 12 Sep 2014 15:23:09 GMT

i mispelled the last line its:

FROM $(Datasource)\dummydata.qvo (ansi, txt, delimiter is '\t', embedded labels);