topic How to call QVD files up from my QVW folder? in QlikView

How to call QVD files up from my QVW folder?

Tue, 19 Nov 2013 09:12:16 GMT

Hi, i have a problem of calling of my qvd files up from my folder path.

My qvw is here..

..\Application Data\ QlikTech\ Documents\ Development \ Ascella\

while my qvd is from this path.

..\Application Data\ QlikTech\ Documents\ Databases \ Ascella\

and my code is like this.

LOAD [Name],

[Age],

[Address];

[Location];

FROM

[QVD\Personal_Info.QVD]

(qvd);

Hope you could help me.

Sherwin

Re: How to call QVD files up from my QVW folder?

dmohanty — Tue, 19 Nov 2013 09:15:55 GMT

Guess you need to put the correct path of the QVD files in your script. Try below:

PersonalInfo:

LOAD [Name],

[Age],

[Address],

[Location]

FROM

[..\Application Data\ QlikTech\ Documents\ Databases \ Ascella\Personal_Info.QVD]

(qvd);

And don't put SEMICOLON besides the column names as seen in your script.

Re: How to call QVD files up from my QVW folder?

Tue, 19 Nov 2013 09:16:22 GMT

Hi,

LOAD ... FROM [..\..\QVD\Personal_Info.QVD]

...
If you use relative path, you have to go up in the directories in order to name the real one.

Or you can use also absolute path (but the full path should remain the same)

Fabrice

Re: How to call QVD files up from my QVW folder?

kaushiknsolanki — Tue, 19 Nov 2013 09:16:43 GMT

Hi,

Try this one.

Load *

From ..\..\ Databases \ Ascella\ABC.qvd(qvd);

Regards,

Kaushik Solanki

Re: How to call QVD files up from my QVW folder?

Tue, 19 Nov 2013 09:17:07 GMT

LOAD [Name],

[Age],

[Address];

[Location];

FROM

[..\Application Data\ QlikTech\ Documents\ Databases \ Ascella\QVD\Personal_Info.QVD]

(qvd);

It will work, check...

Re: How to call QVD files up from my QVW folder?

kalyandg — Tue, 19 Nov 2013 09:56:00 GMT

Hi,

set a variable for the qvd path where do you have.

for example:

set qvdpath='..\Application Data\ QlikTech\ Documents\ Databases \ Ascella\';

now apply the variable in the load script... as below

LOAD [Name],

[Age],

[Address];

[Location];

FROM

$(qvdpath)Personal_Info.QVD(qvd);

Try this...

Thanks and Regards,

Kalyan

Re: How to call QVD files up from my QVW folder?

Tue, 19 Nov 2013 10:34:23 GMT

Thanks for the reply guys..

all answers is correct, but i used Kalyan Sundaram did, to set a variable for qvd path to shorten my codes.

Thanks again

Re: How to call QVD files up from my QVW folder?

ngulliver — Wed, 20 Nov 2013 11:26:01 GMT

Hi, Sherwin.

I know this has been answered but I thought I would also point you to a blog about QVDs:

http://www.quickintelligence.co.uk/qlikview-qvd-files/

Regards,

Neil