Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qvd

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

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

9 Replies
Not applicable
Author

Hi,

Qvd = QlikView Data

suniljain
Master
Master

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

Not applicable
Author

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?

Not applicable
Author

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

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Not applicable
Author

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 .

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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-t...

-Rob

Not applicable
Author

Thanks Rob ,

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

Not applicable
Author

hi XXX

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

Thanks rob