topic How to create QVX file? in QlikView

How to create QVX file?

Thu, 02 Dec 2010 13:04:32 GMT

I created QVX file same like QVD, but getting error at the time of QVX load.

How to create QVX file?

renjithpl — Thu, 02 Dec 2010 13:12:44 GMT

Same as how you create a QVD file. What error you are getting ?

How to create QVX file?

Thu, 02 Dec 2010 13:33:16 GMT

Create QVX

TestAccount:

SQL SELECT TOP 10 AccountNumber,AccountName

FROM Account ORDER BY AccountID DESC;

STORE TestAccount INTO

Load QVX

LOAD AccountNumber,AccountName FROM (QVX);

error : Execution of script failed. Reload old data? Yes or No.

How to create QVX file?

Fri, 03 Dec 2010 07:45:52 GMT

store * from t1 into t1.qvx (qvx);

How to create QVX file?

Qlik_Trigg — Fri, 03 Dec 2010 08:19:15 GMT

The QVX (Data Exchange) format introduced with V10 is intended to be used to pass data to QlikView in an optimized form directly from an external source. It is an open format with an XML based description that an external routine can write to. Hence you can use it in conjunction with a custom data connector to attach to data sources that do not have traditional ODBC/OLE-DB connectivity. Further you can use it in two formats -

1. As a persistent file format. If your target data source pushes data out you can capture it and persist to a QVX file that can be loaded as a part of your script

2. As a named pipe - if you target source exposes its own 'query' interface your custom connector and the QlikView script can support direct calls to fetch data during the load. The connector can pass the data into the script in the QVX format.

QVX is intended to solve the common request from people looking to write directly to a QVD format from an external source. Given the highly optimized nature of a QVD file, we have introduced this new QVX format to address the request. QVX is optimized though not to the extent of a QVD file.

What you don't want to confuse QVX into is the notion of storing into QVX from within a script. If you are passing data between QVW processes then a QVD is the right way. There is no advantage of using QVX in this process.

Regards

John T

How to create QVX file?

Fri, 03 Dec 2010 22:29:17 GMT

Hi John,

I haven't seen any example or documentation for how an external application can create a qvx file. It's not explained in the user manual. Can you point me to an example or doc?

Thanks!

-Tim

How to create QVX file?

rwunderlich — Sat, 04 Dec 2010 09:45:40 GMT

Tim,

The QVX file format is documented in a PDF that installs wit the V10 SDK.

-Rob

How to create QVX file?

Thu, 09 Dec 2010 14:39:49 GMT

Issue a STORE .. INTO x.qvx (qvx) and look at the file in hex editor . It is a nice supplement to the official PDF .

-Alex

How to create QVX file?

Thu, 09 Dec 2010 16:42:46 GMT

see here: http://community.qlik.com/media/p/149203.aspx

How to create QVX file?

Tue, 01 Feb 2011 17:51:37 GMT

I haven't seen any example or documentation for how an external application can create a qvx file. It's not explained in the user manual. Can you provide the QV Document which explain me the same.

How to create QVX file?

sukydhak — Tue, 15 Mar 2011 16:22:34 GMT

Attached is a sample.

Re: How to create QVX file?

cjgorrin — Fri, 19 Apr 2024 12:48:26 GMT

Still 14 years later, no good official documentation on the QVX format. The QVX_QV_DUAL format is not explained in the documentation, yet, this is the format Qlik Sense chooses whenever you export a table as QVX.

The only place where I found any documentation about the QVX_QV_DUAL data type: https://community.qlik.com/cyjdu72974/attachments/cyjdu72974/qlikview-app-development/1061458/1/QlikView%2520QVX%2520File%2520Format.pdf (hopefully it will not be deleted anytime soon)