Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Store into qvd

I want to store each table that I use into a qvd.

When I reload the script I get the error that loading the script has failed.

It was running perfectly before I added the store expression.

Can anyone see what is wrong with my script?

Kind regards,

Katleen

Tags (3)
1 Solution

Accepted Solutions
senpradip007
Valued Contributor III

Re: Store into qvd

I think first you should  try with absolute path then with relative one.

7 Replies

Re: Store into qvd

Hi

Do you have QVD folder and that path location which you are mentioned is validate?

aveeeeeee7en
Valued Contributor III

Re: Store into qvd

Don't use Brackets [ ]

Use this:

Store projects into ..\QVD\projects.qvd(qvd);

Drop Table projects;

Regards

Aviral Nag

amit_saini
Honored Contributor III

Re: Store into qvd

Try This:

projects:

LOAD id                                                                     as project_id,

    `continent_id`,

    `country_id`,

    `branch_id`,

    `region_id`,

    `agency_id`,

    name                                                                     as project_name,

    description,

    active                                                                     as project_active,

    status                                                                     as project_status,

    account,

    type,

    `is_deleted`                                                            as project_is_deleted;

  

SQL SELECT *

FROM `ciweb_denc_qlikview`.projects WHERE is_deleted="0";

Store projects into ..\QVD\projects.qvd(qvd);

Drop Table projects;

Thanks,
AS

Not applicable

Re: Re: Store into qvd

This is the qvw that I use and the folder where I want to store my qvd.

Not applicable

Re: Re: Store into qvd

Still doesn't work.

I tried it without the brackets.

senpradip007
Valued Contributor III

Re: Store into qvd

I think first you should  try with absolute path then with relative one.

Re: Store into qvd

HI

Try like this

Store projects into projects.qvd(qvd);

If its stored, then problem in the location which you trying to save.

Community Browser