Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
hargreaves
New Contributor III

SQL Script from .QVD file

It is possible to use SQL Script to extract information from .QVD files?

ExampleTable:

SELECT A, B, C

FROM

(qvd);

Something like this...

Thank you so much!

1 Solution

Accepted Solutions

Re: SQL Script from .QVD file

No. A qvd file is simply a binary file with memory dump of a table from a qlikview or qlik sense document. It is not an SQL database management system. You load data from a qvd in Qlikview or Qlik Sense with the LOAD statement.

ExampleTable:

LOAD A, B, C

FROM

(qvd);


talk is cheap, supply exceeds demand
3 Replies

Re: SQL Script from .QVD file

Not sure if you want to do just this:

ExampleTable:

LOAD A,

          B,

          C

FROM

(qvd);

Re: SQL Script from .QVD file

No. A qvd file is simply a binary file with memory dump of a table from a qlikview or qlik sense document. It is not an SQL database management system. You load data from a qvd in Qlikview or Qlik Sense with the LOAD statement.

ExampleTable:

LOAD A, B, C

FROM

(qvd);


talk is cheap, supply exceeds demand
jlongoria
New Contributor III

Re: SQL Script from .QVD file

I'm going out on a limb with this post. If you are interested in reading information about the QVD file (metadata) not the contents of the QVD file itself then the link below should help. If not. . .what they said.

How To Read Meta Data From A QlikView QVD

Community Browser