Fast viewer for QlikView's QVD files
Fast QVD viewer
Professional tool for QlikView developers
QViewer is a fast (10 mln rows load in 1-2 seconds) and lightweight (<1MB) standalone utility for viewing, filtering and profiling QlikView's QVD files, created by a QlikView developer for QlikView developers.
QViewer saves you time you spend for developing and debugging QlikView applications, especially when you're dealing with applications designed by someone else. With only a couple of clicks you can look inside any QVD, find out what application created it and when, filter and search data, check fields for duplicates, detect nulls, and do many more without creating a throwaway QlikView application every time, as you would otherwise do.
And even more than that — using a simple trick you can inspect any resident table at any point of the loading script of a QlikView application with only a single line of code.
- View row-level data of a QVD file
- Automatically pre-calculated counts (null count, number count, text count) for all fields and distinct values
- Instant one-click listboxes — double-click a column header to get searchable list of unique field values with counts
- Qlik-style associative filtering (with selectable nulls)
- Full-table phonetic search
- Table and column metadata obtained from the XML header of a QVD file, including lineage information with SQL statements
- Partial (limited) load for viewing very large files (>2GB)
- Aggregate, calculate new columns, export data (requires free EasyMorph installed)
- Portable — just copy qviewer.exe to your USB-drive (.NET 4.5 or higher required on guest OS)
What is a QVD file
QVD is a special format of files that are generated by QlikView applications for storing table data — one table per one QVD file. Since structure of a QVD file reflects native in-memory representation of data in QlikView, QlikView applications can read and write them very quickly (up to several millions of records per second), which makes QVD files the fastest data source possible for QlikView. Therefore, using QVD files is the preferred way for accumulating historical data by QlikView applications and exchanging information between them.
One QVD file stores information about one table. From a technical standpoint, a QVD file consists of an XML header and a binary block with row-level data. The XML header contains valuable metadata about the table, like name of QlikView application which created the file, or SQL statements that were executed prior to storing the file. The binary block holds compressed row-level table data. All information from the XML header and the contents of the binary block can easily be viewed with the help of QViewer — that's exactly what it was made for.