topic generate qvd and store data in QlikView

generate qvd and store data

Fri, 12 Jul 2013 01:54:37 GMT

Hi,

I'm trying to store my data into a qvd, I used scripts like:

Store

Table into Table.qvd

1. I haven't specify the path where I want to save the qvd, but after reload I can't find it. Where's the default path of a generated qvd?

2. How to make the qvd under a specific path?

3. If I reload again, will the new data override the old data in the qvd?

Peter

Re: generate qvd and store data

Sokkorn — Fri, 12 Jul 2013 03:25:08 GMT

Hi Peter,

Response to your question:

1. Make sure your script load successfully (if possible share your script here and then we figure out together). And if you we don't specific path of QVD then *.qvd file should stay at the same directory of your *.qvw

2. To save QVD in specific path we can use Store MyTable Into ;

3. Of cause the new data will override the old one.

Regards,

Sokkorn

Re: generate qvd and store data

mohanrajsubrama — Fri, 12 Jul 2013 04:14:31 GMT

Hi Peter,

Find the attached .Hope this will help you.

Regards,

Mohanraj Subramanian.

Re: generate qvd and store data

Fri, 12 Jul 2013 05:14:22 GMT

Hi use below statement. Hope this helps.

STORE [TableName] INTO '..\MyPath\QVDs\Test.qvd' (qvd);