topic Scripting the creation of a QVO in QlikView

Scripting the creation of a QVO

Thu, 14 Oct 2010 19:19:49 GMT

What is the syntax to script the exporting (store) contents of an object to a QVO?

I want to use the QVO has a data table in QVW.

Thanks

Glen

Thu, 14 Oct 2010 19:33:35 GMT

First you´ll store your table at qvw generate qvd.Use this syntax

STORE YOUR_TABLE INTO [YOUR_PATH \ YOUR_NAME.QVD];

and after that....just read from another application....

Thu, 14 Oct 2010 20:29:59 GMT

Would the extension be QVO instead of QVD?

Thu, 14 Oct 2010 21:50:23 GMT

the extension is QVD (QlikView Data)

pover — Thu, 14 Oct 2010 21:55:53 GMT

Are you taking about the script to export an chart object using a macro or in the load script when you are loading data and want to save a table?

For the marco, the function would be:

set obj = ActiveDocument.GetSheetObject("CH01")
obj.ExportEx "C:\test.qvd", 4

QVO is not an option. These are you file format options:

Export format
0 = HTML
1 = Text delimited
2 = bitmap image
3 = XML
4 = QVD
5 = BIFF (Excel)

You can also create an action that exports raw data and you can export that data into the qvo format.

Regards.