topic Re: Store into qvd in QlikView

Store into qvd

Tue, 22 Jul 2014 07:07:14 GMT

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

Re: Store into qvd

MayilVahanan — Tue, 22 Jul 2014 07:13:23 GMT

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

Re: Store into qvd

aveeeeeee7en — Tue, 22 Jul 2014 07:13:42 GMT

Don't use Brackets [ ]

Use this:

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

Drop Table projects;

Regards

Aviral Nag

Re: Store into qvd

amit_saini — Tue, 22 Jul 2014 07:19:46 GMT

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

Re: Re: Store into qvd

Tue, 22 Jul 2014 07:21:08 GMT

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

Re: Re: Store into qvd

Tue, 22 Jul 2014 07:25:14 GMT

Still doesn't work.

I tried it without the brackets.

Re: Store into qvd

senpradip007 — Tue, 22 Jul 2014 07:29:40 GMT

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

Re: Store into qvd

MayilVahanan — Tue, 22 Jul 2014 07:32:13 GMT

Try like this

Store projects into projects.qvd(qvd);

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