Behind my QVD file
Have you ever considered your QVD files to be more than data files? If your answer is no, then you should keep reading this post.
I was working in my laptop when I found by chance a QVD file that should not have been there. I usually store everything in a server and work in the server so I wondered why that file was there.
When I opened it, I could recognize the data in it and I couldn’t remember why I copied that file from the server to my laptop or why I had created it.
It turns out that QVD files are more than data files. They contain a structure behind that can be very useful. This XML structure can tell you the following about your QVD file:
- Creation date
- QVW file that created the QVD file
- QVD store path
- Table name used to create this QVD file
- Field names, formats, length, etc.
- Query used to pull data before creating the QVD file
- Qlikview Load statement used in the QVW file.
- And more
As we can appreciate, you can have a full understanding of that QVD file without even having Qlkview installed in your environment.
So, how do we see all this information? Simply change the file extension from .qvd to .xml. You can then open your file with any text or XML editor.
You can also load this structure in a QV application and play with the data you get from it. To do this, you should:
- Double click your QVD file
- In the File Wizard window, select XML in the File Type menu.
- Finish and load your application