topic Re: QVD from directly from document QVW in QlikView

QVD from directly from document QVW

antoniotiman — Wed, 26 Mar 2014 19:29:25 GMT

Hi,

can I create directly a file QVD from a document QVW ? (without executing script)

thanks in advance

regards

Re: QVD from directly from document QVW

MarcoWedel — Wed, 26 Mar 2014 19:34:27 GMT

you've got to script e.g. like this:

Store $(vTable) into $(varDataStorePath)$(vTable).qvd;

regards

Marco

Re: QVD from directly from document QVW

its_anandrjs — Wed, 26 Mar 2014 19:34:47 GMT

Hi,

NO i think not possible at least you have a table with table name and a STORE command like

Tablename:

Load *

From Location;

STORE Tablename into Tablename.qvd;

Hope this helps

Thanks & Regards

Re: QVD from directly from document QVW

antoniotiman — Wed, 26 Mar 2014 19:41:18 GMT

NO,

without executing script.

thanks

Re: QVD from directly from document QVW

Bill_Britt — Wed, 26 Mar 2014 19:49:19 GMT

No, you can't do it without running a script. You can use the QMC to generate QVDs.

Bill

Re: QVD from directly from document QVW

rbecher — Wed, 26 Mar 2014 19:49:58 GMT

Hi Antonio,

you can Export a Chart as QVD (using right click).

- Ralf

Re: QVD from directly from document QVW

rwunderlich — Wed, 26 Mar 2014 19:50:34 GMT

Yes, you can.

Create a Straight Table that contains the fields you want.

Right-Click the table, select Export and then select the QVD file type.

-Rob

Re: QVD from directly from document QVW

MarcoWedel — Wed, 26 Mar 2014 20:00:01 GMT

Hi Rob,

how can I do that, I can only export these types:

regards

Marco

Re: QVD from directly from document QVW

rbecher — Wed, 26 Mar 2014 20:03:24 GMT

Is it a Table Object instead of a Chart?

Re: QVD from directly from document QVW

antoniotiman — Wed, 26 Mar 2014 20:07:12 GMT

thanks Rob and Ralf,

but the chart contains 190 fields.

Regards

Re: QVD from directly from document QVW

MarcoWedel — Wed, 26 Mar 2014 20:11:43 GMT

you're right, it has been a table.

Never noticed that's a difference in terms of export formats.

thanks

regards

Marco

Re: QVD from directly from document QVW

rbecher — Wed, 26 Mar 2014 20:34:10 GMT

Why this is a problem?

Re: QVD from directly from document QVW

antoniotiman — Wed, 26 Mar 2014 21:03:33 GMT

because I must create a Straight Table from table with 190 columns and besides the format of the fields would be different in the file QVD when I create it.

Re: QVD from directly from document QVW

rbecher — Wed, 26 Mar 2014 21:09:06 GMT

But there is another way, if I'm understanding it right:

BINARY Load the QVW in a second QVW and the place a STORE command to pull out the data there. The script from the first QVW will not be executed..

Re: QVD from directly from document QVW

antoniotiman — Wed, 26 Mar 2014 21:25:27 GMT

Thanks Ralf.

Regards

Antonio