Fast QVD viewer

Professional tool for QlikView / Qlik Sense developers

QViewer is a fast (10 mln rows load in 1-2 seconds) and lightweight (<1MB) standalone utility for viewing, filtering, and profiling Qlik's QVD files, created by a Qlik developer for Qlik developers.

QViewer saves you time you spend for 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 many more without creating a throwaway Qlik 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.

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)

Screenshot (clickable)

QViewer screenshot

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.

qvd structure

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.