loading problem

[#1]

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

[ecolomer]

You can use the complet path to access file.

By the wizard you can try

[#3]

hi , thaxks for rply

i cant understand what you are saying can plz elaborate

-lohi

[#4]

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.

[MK_QSL · Accepted solution]

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

[#6]

hi patrick,

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

-lohi

[MK_QSL]

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);

[ecolomer]

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

[#9]

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);

[#10]

i mispelled the last line its:

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