A professional tool for QlikView / Qlik Sense developers
QViewer is a fast (10 mln rows load in 1-2 seconds) and lightweight standalone utility for viewing, filtering, and profiling Qlik’s QVD files, created by a Qlik developer for Qlik developers.
I’ve been using this tool for quite some time now and can tell you it really made my life easier.
Sandra Taha
integpro.se
Save Time Debugging and Developing
With only a couple of clicks you can…
QViewer saves time spent developing and debugging Qlik applications. 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 much more without creating a throwaway Qlik application every time.
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.
This is a great little tool
Matthew Fryer
qlikviewaddict.com
Features
- 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 listboxes — double-click a column header to get a searchable list of unique field values with counts
- Qlik-style associative filtering (with selectable nulls!)
- Full-table search
- Phonetic search (English only)
- View table and column metadata obtained from the XML header of a QVD file, including lineage information with SQL statements
- Obtain memory statistics for each column (userful for memory optimization)
- Partial load for viewing large files that can’t fit entirely in RAM
- Aggregate, calculate new columns, export data (requires free EasyMorph installed)
- Portable — just copy qviewer.exe to your USB-drive (.NET 4.5 or higher is required on guest OS)
This is a complete Godsend. I will certainly be recommending it to my clients.
Steve Dark
quickintelligence.co.uk
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.
The structure of a QVD file reflects the native in-memory representation of data in QlikView and Qlik Sense. Therefore Qlik applications can read and write QVDs very quickly (up to several millions of records per second), which makes QVD files the fastest data source possible for Qlik apps. This makes QVD files the preferred way for accumulating historical data by Qlik applications, and exchanging information between them.
One QVD file stores information about one table. From a technical standpoint, a QVD file consists of XML header and a binary block. The XML header contains valuable metadata about the table, such as the name of QlikView application that 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.
Very nice and very useful.
Oleg Troyansky
naturalsynergies.com
Start working with a professional tool made for QlikView / Qlik Sense developers
Frequently Asked Questions
Every license is perpetual. The price for license includes 12 months of free updates. Further updates cost 50% of the regular price.
Licensee may have unlimited number of installations.