Q5 - What is created and stored in QVD Files

[#1]

Hi Community,

Working on QVD file. I try loading my data to qvd  sample below

DATAQVD << Table1 153 lines fetched

DATAQVD << Table1 313 lines fetched

I see first over all 153 records are transfered from my table to qvd, what is the next 313 lines from same table and why ?

What does QVD holds internally and what mode ?

Cheers

[#2]

Peter - Thanks. Yes I agree with you. I was not having any problem with script or load. I was trying reload and table transfer and I noticed why is this happening. Where my table and data are unique and no duplication.

Well 1 question on this, if I try executing my reload again. Will the concatenated avoided and it will show only a single statement DATAQVD << Table1 153 lines fetched

Or how it behaves ?

And it is possible to read QVD files ?

[Peter_Cammaert]

• Probably not, but I cannot peek through the world and look in the inside of your QlikView document. Although you may not think so, Manish did ask a very sensible question. If you want correct answers to those questions (and not some arbitrary guesses) post your script, or at least the part that deals with the DATAQVD table. We'll be able to explain every detail to you.
• Inside QlikView: yes. Outside QlikView: no, except if you are able to build your own software and obtain a Qlik SDK license. There are other tools that are able to load QVD's (they use the Qlik SDK) but that's probably not what you mean, is it?

Peter

[#4]

I agree with Manish and You. But posting the data is not possible, I deal with real time data and highly confidential. Thanks in advance I will take it from here on ward.

[Peter_Cammaert]

We're not asking for data or your document, just a part of the script. In QV desktop, press Ctrl-E, navigate through the text until you encounter the part that deals with DATAQVD, select a chunk, press Ctrl-C and paste it in a reply. That's it.

On the other hand, if you are satisfied with the answers, please close the discussion so that others will find solutions/answers if they encounter the same situation. Thanks.

Peter

[_rohitgharat]

Hi Varun,

             It would be better if you post your script here so that we can understand your problem thoroughly and provide you with solution as early as possible.

Thanks,

Rohit

[#7]

Rohit Gharat > Peter > Manish

Thanks for all the udpate and feedback. We can read QVD file. the xml data generated in it and the data captured in the file.

Closing the post. Thanks all

[#8]

Try to create and script of your and have a qvd file. You can figure out this !!