Conversion report

QV2QS generates a conversion report after each run. The report breaks down what was converted, what requires manual attention, and how each object was mapped from QlikView to Qlik Sense.

Recommended triage workflow for the Excel report:

1. Open Follow-up_Objects and sort by the Category column. Address Error rows first (objects that failed to convert entirely), then Placeholder rows (objects that need rebuilding as a different Qlik Sense type), then Adjustments Required rows (objects that converted but need manual refinement).
2. Open Sheet_Impact. The worksheet is pre-sorted by follow-up count (Adjust + Placeholders + Errors) descending. Start post-conversion work on the sheets at the top of the list.
3. Open Overflow_Actions to review any objects where dimensions or measures were moved to the alternatives collection. Decide whether to keep the overflow items as alternatives or restructure the visualization.
4. Open Expression_Findings to review set analysis expressions with quoting patterns that behave differently in Qlik Sense. QV2QS fixes single-quoted search values by default. The unquoted bare values fix is experimental and disabled by default. The Status column indicates whether each finding was auto-fixed during conversion, requires manual review, or has no automatic fix available. Focus on rows with a Needs review or No fix available status. The Suggested Fix column shows the corrected expression text for fixable patterns. When automatic fixing is disabled (--noFixSingleQuotedSearch, --noFixUnquotedSetValues), apply the suggested corrections manually.
5. Open Data_Model_Fields and Data_Model_Tables to review the source data model structure, field cardinality, and table row counts. Sort by Byte Size (MB) descending to identify the largest contributors to app size.
6. Open App_Info to review the last reload time, section access status, and data lineage connections.
7. Open Analysis to review load script findings, macro cross-references, and SaaS sizing. These findings affect the app broadly, not individual objects.

Console report

The console report is printed to the terminal at the end of every conversion. The report includes an executive summary with key metrics, a follow-up scope breakdown, and optional detail tables.

By default, the console report includes metric cards, a follow-up scope summary, and detail tables (sheet impact, object mapping, follow-up objects, and type counts). To suppress the console report entirely, use --noReport.

The executive summary displays the following metrics:

• Sheets — Number of sheets in the converted app.
• Objects (in scope) — Number of QlikView objects counted for conversion scoring. Built-in objects (Current Selections, Search) are excluded.
• Auto-converted — Objects that converted without any manual follow-up required.
• Follow-up — Objects that require attention after conversion, broken down by type count and affected sheets.
• Built-in skipped — QlikView objects that have no Qlik Sense equivalent because the functionality is built into the platform.
• Variables — Number of variables included in the converted app.
• Media — Number of unique images (backgrounds, button images) uploaded.
• Runtime — Conversion duration in seconds.

Excel report

The Excel report contains the same data as the console report plus additional detail worksheets for sharing with stakeholders. By default, an Excel report is generated automatically. To specify a custom file path, use --reportXlsx PATH. To disable the Excel report, use --noReportXlsx.

Reporting arguments include --report, --noReport, --reportXlsx, --noReportXlsx, and --reportIncludeBuiltIns. For descriptions and defaults, see Argument reference.

Excel worksheets

The Excel report contains the following worksheets organized by priority. Summary worksheets appear first, followed by worksheets that require action, then context worksheets, reference data, and finally deep-dive worksheets containing raw JSON properties. Each worksheet is an Excel table that supports filtering and sorting. Worksheet tabs are color-coded by tier: green for summary, amber for action required, blue for context, grey for reference, and uncolored for JSON deep-dive.

The sections below describe each worksheet and the associated columns in detail.

Summary

Executive_Summary — Key conversion metrics with hyperlinks to the relevant detail worksheets.

KPI_Definitions — Definitions for all scoring terms used in the report.

Action required

Follow-up_Objects — Every object that requires manual follow-up after conversion.

Follow-up_Scope — Breakdown of follow-up objects by outcome category.

Expression_Findings — Expression issues found during analysis. This worksheet covers unsupported QlikView chart functions and set analysis quoting patterns that behave differently in Qlik Sense. This worksheet is only present when issues are detected. For background, see Analysis.

Analysis — QlikView feature and compatibility findings. This worksheet is only present when findings are detected. The worksheet contains multiple tables.

The findings table lists all detected gaps.

The confidence legend table defines the confidence levels.

The sizing details table provides SaaS resource estimates.

The macro definitions table lists all VBA macros defined in the QlikView document.

The macro invocations table shows every object-to-macro call.

The macro cross-reference notes table lists macros that are invoked but not defined in Module.txt.

The macro source code table displays the full contents of Module.txt with line numbers. This table is present only when the QlikView document contains VBA macros.

The developer bookmarks table lists all bookmarks in the QlikView document.

Overflow_Actions — Actions taken when a QlikView object exceeds the dimension or measure limits for the target Qlik Sense visualization type.

App_Info — Application-level metadata and data lineage. The worksheet contains two tables. The first table shows application properties. The second table lists data source connections.

The application properties table displays key-value pairs.

Properties include Last Reload (Local), Last Reload (UTC), Window Title, Has Section Access, Dynamic Reduce Data, QV Build Number, Base RAM (GB), and SaaS Tier. The SaaS sizing properties are included only when ByteSize metadata is available.

The data lineage table lists all data source connections parsed from the QVW binary.

Context

Sheet_Impact — Per-sheet scoring sorted by follow-up count (highest first).

Drivers_By_Type — Follow-up counts grouped by QlikView object type. Highlights the types that require the most manual work.

Object_Mapping — Complete mapping from QlikView object types to Qlik Sense object types.

Overflow_Summary — Aggregated overflow statistics. This worksheet contains two tables.

The first table summarizes overflow actions by type.

The second table summarizes conversion outcomes caused by overflow handling.

Reference

Variables — All variables included in the converted Qlik Sense app.

Data_Model_Fields — All fields in the QVW data model, excluding system fields. The title row displays the total field count, system field count, and total byte size. A totals row at the bottom of the table sums the numeric columns.

Data_Model_Tables — All tables in the QVW data model, excluding system tables. The title row displays the total table count, system table count, and total byte size. A totals row at the bottom of the table sums the numeric columns.

Sheet_Mapping — Mapping of QlikView sheet identifiers to generated Qlik Sense sheet identifiers.

Type_Counts — Combined count of all QlikView source types and generated Qlik Sense types.

Built-in_Skipped — Objects excluded from scoring because the functionality is built into Qlik Sense. This worksheet is only present when --reportIncludeBuiltIns is used.

Deep-dive (JSON)

Objects_Index — Master list of every in-scope object with identifiers, outcome, and dimension/measure counts.

Object_Placements — Position and size of each object on each sheet in QlikView coordinate units.

Object_Dimensions — All dimensions parsed from each QlikView object.

Object_Measures — All measures parsed from each QlikView object.

Selection_Fields — Fields used in selection objects such as listboxes and multi-boxes.

Object_Actions — Triggered actions associated with each object (on-activate, on-select).

Object_Styles — Visual styling details parsed from each QlikView object.

Objects_QV_Settings — Full QlikView XML settings for each object as parsed key-value pairs.

Objects_QS_Property — Generated Qlik Sense qProperty JSON for each converted object. A compact subset is shown to reduce cell size.

Objects_QS_qProperty — Full resolved qProperty JSON for each converted object. This worksheet contains the same columns as Objects_QS_Property, except the final column shows the complete qProperty instead of the compact subset.

Objects_Compare — Side-by-side comparison of QlikView source settings and resolved Qlik Sense output for each object.

Dimensions, measures, and variables

QS_Dimensions — All dimensions in the generated Qlik Sense objects, resolved from the on-disk JSON output.

QS_Measures — All measures in the generated Qlik Sense objects, resolved from the on-disk JSON output.

Dim_Mapping — Side-by-side mapping of QlikView dimensions to Qlik Sense dimensions, joined by object ID and index.

Measure_Mapping — Side-by-side mapping of QlikView measures to Qlik Sense measures, joined by object ID and index.

Learn more

• Automation score
• Conversion outcomes
• Analysis