How to call QVD files up from my QVW folder?

[#1]

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

[dmohanty]

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.

[#3]

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

[kaushiknsolanki]

Hi,

     Try this one.

     Load *

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

Regards,

Kaushik Solanki

[#5]

LOAD [Name],

     [Age],

     [Address];

  [Location];

FROM

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

(qvd);

It will work, check...

[kalyandg · Accepted solution]

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

[#7]

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

[ngulliver]

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