Fast viewer for QlikView's QVD files
Fast QVD viewer
The application is offered "as is", without warranties and liabilities. You may not resell it, disassemble or offer it under a different branding.
The free version is limited to
50'000 100'000 rows.
If a QVD file has more rows then only the first 100'000 will be loaded.
Filtering and counts will be limited to only the loaded rows.
To get the full version purchase a license.
Update from ver.2 to ver.3
Version 3 requires a new license key. License keys for older versions don't work with version 3. Keys issued after August 1st, 2015 are eligible for a free update (see Release notes for more details). Keys issued before August 1st, 2015 are updated at 50% of the regular price.
Known issues and limitations
- First launch can take a bit longer than normal. Subsequent launches are instant.
- On some versions of Windows the installer doesn't associate QViewer with .qvd file extension automatically. Make such association manually, if needed.
Virus or malware alerts
QViewer is routinely checked for malware. Although some antiviruses may give false positive warnings. If you get such warning please check the size of downloaded archive. Let me know if it's noticeably larger than indicated in the download link (see my email in my blog). The installer is signed with a code signing certificate issued to EasyMorph Inc.
QViewer now can load files larger than 2GB (technically up to 2bln rows).
Redesigned Partial Load workflow: removed the Partial Load button, added suggestion to perform partial load for files larger than defined threshold (512MB, 1GB, 2GB, 4GB or 8GB).
When a file is loaded partially, now QViewer indicates which metrics in Table Metadata can be affected by partial load — they are shown red.
The "Generate script" feature now can include field comments from QVD XML header into the generated script.
Bugfix: the Field Values dialog didn't close on pressing Esc.
Bugfix: Square brackets missing in some cases when generating LOAD statement.
Bugfix: Dual values with zero-length text part crashed application.
|3.1.1||Bugfix: Crash when attempting to open a file with more than 113 mln. rows.|
|3.1||New quick filter: Ctrl + double-click to remove values from table. Memstat metrics in Table Metadata — Column size (bytes), Avg.bytes per Symbol. All columns sortable in Table Metadata. Read more about the memstat metrics.|
|3.0||Qlik-style associative filtering. Full table search. Phonetic search (English only). Cell metadata. Search/select fields by name. Faster indexing and counting. New start screen. New license key format. Read release notes.|
|2.2.0||New installer. Automatic check for updates. Right-click menu for columns. Formatting for numbers.|
|2.1.4||Fixed bug: license key couldn't be installed.|
|2.1.3||Fixed bug with disappearing Lineage Details and About windows. Fixed bug with multiple auto-reload notifications. Improved layout of Lineage Details. Added file size to File Metadata.|
|2.1.2||Fixed bug with disappearing columns in Table Metadata window. Fixed bug with missing scrollbars in lineage details window.|
|2.1.1||Fixed bug with error message on first start for licensed users. Re-enter Licensee email in About dialog if necessary.|
|2.1.0||You can now drag-n-drop QVDs into QViewer to open. Added Fit to content button to automatically resize columns. Right-clicking a cell shows Copy cell command. Alignment of values in cells now depends on type — text/dual aligned left, numbers aligned right. Nulls now have light grey background for easier distinguishing. Added automatic reloading if opened file has been changed by another application. Fixed bug with exception window showing up when two or more QViewer instances are open. Downgraded requirements to .NET ver.4.5.|
|2.0.4||Fixed bug — Find in table didn't work correctly when one or more columns were hidden and could occasionally cause "Argument Out of Range" exception.|
|2.0.3||Fixed bug — Morph It didn't work when file name contained space.|
|2.0.2||Minor fixes in Field Values — now fully resizeable, double click value to find it in the main table. When opened keyboard focus set to search box.|
|2.0.1||Minor fixes in Table Metadata window — search field by typing first letter, trigger checkboxes with multiple selection.|
|2.0.0||Major upgrade. New look & feel. Greatly improved load speed, significantly decreased memory consumption. Added Getting Started page. Free version's limit increased to 100'000 rows. Partial load offered for files above 500MB (previously 200MB). Removed Query (replaced with integration with EasyMorph).|
|1.4.8||Fixed bug — in free version partial load of a QVD with file size more than 2GB caused error "Arithmetic operation resulted in an overflow".|
|1.4.8||Added one more time-saver — list of recent files. Added hot key F4 for Metadata dialog. Fixed minor bug with wrong total count in listboxes in some cases. Limit for free version increased from 10'000 to 50'000 rows.|
|1.4.4||Modified File Metadata dialog for better usability. Now if the QVW that created the QVD is located on the same computer its name will be shown as link. Clicking the link will open app location. Also lineage information can now be viewed in special dialog optimized for long multiline statements which is convenient for viewing SQL queries from source app (for QV11 and up).|
|1.4.3||Added Generate Script button to Fields — it produces loading script for checked fields. Also in Fields if field uniqueness is very close to 100.00% but is not exactly 100% it will be shown as "<100.00%" to indicate existing duplicates.|
|1.4.2||Renamed columns to fields. Query can now run without selecting dimension thus showing totals. Added file creation date to Metadata. Metadata and Fields now always show total number of rows in QVD even in case of partial load.|
|1.4.1||Values inside listboxes can now be sorted by counts and by alphabetical order (just click respective column header). Also added sorting by name to list of columns.|
|1.4.0||Changed installation kit from ClickOnce to NSIS. Introduced unlimited paid and limited free versions. Rebranded to EasyQlik QViewer.|
|1.3.1||Turned off standard ClickOnce autoupdate — it needs to be tested more thoroughly. If you experienced problems with update - uninstall and reinstall application.|
|1.3.0||Introduced Partial Load — for loading a limited set of rows. When loading files >100MB Partial Load is offered automatically.|
|1.2.0||Introduced Query — simple queries to QVD data that aggregate one field grouping by another field and WHERE-like filtering by 3rd one.|
|1.1.3||Fixed bug: application crashes if a new file is opened before background analysis has finished|
|1.1.2||added Find in table in Values dialog — it performs search of value in the main table (F3 resumes search); also added filtering by value type (All / Numbers / Text) into Values dialog|
|1.1.1||keyboard shortcuts for Columns dialog (F5), and Values dialog (F2); more intelligent propagation of background analysis results (no need to reopen dialogs)|
|1.1.0||displays dates and time stamps; background calculation of null counts, text counts, numeric counts for each field, also total counts for every unique value of a column (may take some time on large files)|
|1.0.2||possibility to show/hide selected columns, columns metadata moved to View/Columns menu|
|1.0.1||clicking column header now displays all unique values in that column|
|1.0.0||initial release: view row-level QVD data , table and column metadata|