topic Qvd in QlikView

Qvd

Mon, 24 Jan 2011 06:00:14 GMT

Hi,

When we create the Qvd file or wile calling the Qvd file we are specifying as .QVD(Qvd); What does it refers and what is the impact

Qvd

Mon, 24 Jan 2011 06:13:12 GMT

Hi,

Qvd = QlikView Data

Qvd

suniljain — Mon, 24 Jan 2011 10:47:36 GMT

QVD is extension of data file generated by qlikview. it is proprietary of Qliktech International.

Qvd

Mon, 24 Jan 2011 11:28:45 GMT

Hi Sunil/Srividhya.

Thanks for your response.

When loading the data from the Qvd file if you are using the syntax as

Load * from a.qvd; -------- It is not getting executed

Load * from a.Qvd(Qvd);------It is working fine.

Any architectural change in behaviour of the second one?

AW:Re: Qvd

Mon, 24 Jan 2011 14:21:06 GMT

Hi XXX,

you can find the ()-bracket at the end of the load-statements reading from "type file".

Text-files like:

LOAD @1
FROM
(txt, codepage is 1252, no labels, delimiter is '\t', msq);

reading from Excel-files similar:

LOAD .... FROM [xyz.xls] (biff, embedded labels, table is Tabelle1$);

So I think to have a consistent syntax the load-statement to read from a qvd(-file) has also the ()-brackets. Even there is only one content (qvd) at the moment, but ready for future options.

Regards, Roland

AW:Re: Qvd

rwunderlich — Tue, 25 Jan 2011 07:25:42 GMT

If you omit the (qvd) specification when reading from the qvd, the default filetype is (txt) is used . Which is why you must specify (qvd) when loading from a QVD.

-Rob

Qvd

Tue, 25 Jan 2011 15:16:47 GMT

Thanks for all your responses.

I just tried to load the Qvd data without giving (Qvd) in barcket. it is showing xml data about the Qvd .

Qvd

rwunderlich — Tue, 25 Jan 2011 19:22:15 GMT

Want to learn more about QVDs? I'll be presenting a webinar on QVD February 2.

http://www.qlik.com/us/company/events/webinar/2011/qliklearn-understanding-and-best-practices-with-the-qvd-file-format

-Rob

Qvd

Mon, 07 Feb 2011 05:51:07 GMT

Thanks Rob ,

The webinar was very much useful.I am looking forward to know about forthcoming webinars or events like this

Re: Qvd

Mon, 23 Sep 2013 16:54:54 GMT

hi XXX

i guess rob already gave you the right answer. You can close this thread as answered.

Thanks rob