Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

How to call QVD files up from my QVW folder?

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

1 Solution

Accepted Solutions
Partner
Partner

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

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

View solution in original post

7 Replies
Partner
Partner

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

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.

Not applicable

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

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?

Hi,

     Try this one.

     Load *

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

Regards,

Kaushik Solanki

Not applicable

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

LOAD [Name],

     [Age],

     [Address];

  [Location];

FROM

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

(qvd);

It will work, check...

Partner
Partner

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

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

View solution in original post

Not applicable

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

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

Partner
Partner

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

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