Analyzer Results
Analyzer provides an overview of a Qlik application after evaluation. It displays application statistics, highlights findings related to quality, resource usage, and development practices, and provides detailed information about variables, master items, sheets, fields, and tables.
Summary
The Summary tab displays the application's key statistics and findings under Quality, Resource, and Practice.
Application Statistics
The following metrics provide an overview of the application:
| Metric | Description |
|---|---|
| Total Rows | Total number of rows reported for the application. |
| Fields | Number of fields identified in the application. |
| Tables | Number of tables identified in the application. |
| App Open Time | Time taken to open the application, in milliseconds. |
| App Memory | Memory reported for the application. |
| Reload Duration | Time taken to reload the application, when available. |
| Reload Peak Memory | Peak memory recorded during reload, when available. |
If reload information is unavailable, the corresponding value is displayed as N/A.
Quality
The Quality section displays findings related to missing extensions and references. Select More info to view the details associated with each finding.
- Missing Extension: Identifies objects that refer to extensions reported as missing.
- Missing Reference: Identifies references reported as missing.
These findings help identify affected objects and investigate the corresponding extensions or references in the environment.
Resource
The Resource section provides information about unused fields and data model size. It displays used and unused memory, along with the estimated memory savings from removing fields identified as unused.
This information helps identify potential opportunities to reduce unnecessary resource usage. Check field dependencies before removing unused fields.
Practice
The Practice section highlights findings related to application development practices. The findings include:
- Key Field used in Expression: Identifies expressions that use key fields.
- Repeating Expression: Identifies expressions that are repeated in the application.
Select More info to view the details associated with each finding.
Note
The number displayed beside each tab indicates the number of items identified in that section.
Variables
The Variables tab displays the variables identified in the application. Use the search field to find a specific variable. The All variables and Unused only options allow you to view all variables or filter for those identified as unused.
The following details are available:
| Column | Description |
|---|---|
| Variable | Name of the variable. |
| Definition | Definition or expression associated with the variable. |
| Script Created | Indicates whether the variable was created in the script. |
| Usage Count | Number of usages detected by Analyzer. |
| Status | Usage status, when available. |
| Used By | Application objects that use the variable, when available. |
Master Dimensions
The Master Dimensions tab displays the master dimensions identified in the application, along with their definitions, usage details, and duplicate information.
Use the search field to find a specific dimension. The All dimensions and Unused only options allow you to view all dimensions or filter for those identified as unused.
The following details are available:
| Column | Description |
|---|---|
| Dimension | Name of the master dimension. |
| Definition | Definition associated with the dimension. |
| Usage Count | Number of usages detected by Analyzer. |
| Status | Indicates whether the dimension is used. |
| Used By | Application objects that use the dimension, including the sheet and object details where available. |
| Duplicate | Indicates whether the dimension is identified as a duplicate, when available. |
The usage information helps you understand where master dimensions are used across the application and identify dimensions that may be unused or duplicated.
Master Measures
The Master Measures tab displays the master measures identified in the application. Use the search field to find a specific measure. The All measures and Unused only options allow you to view all measures or filter for those identified as unused.
The following details are available:
| Column | Description |
|---|---|
| Measure | Name of the master measure. |
| Definition | Expression or definition associated with the measure. |
| Usage Count | Number of usages detected by Analyzer. |
| Status | Usage status, when available. |
| Used By | Application objects that use the measure, when available. |
| Duplicate | Indicates whether the measure is identified as a duplicate, when available. |
| Calc Time | Calculation time reported for the measure, when available. |
Master Visualizations
The Master Visualizations tab displays information about the master visualizations identified in the application, including their type, row count, and calculation time.
Use the search field to find a specific visualization or measure. Enable Viz deconstruct to expand a visualization and view its associated dimensions and distinct values.
The visualization table includes the following details:
| Column | Description |
|---|---|
| Visualization | Name of the master visualization. |
| Type | Type of visualization object. |
| Rows | Number of rows reported for the visualization. |
| Calc Time (ms) | Calculation time reported for the visualization, in milliseconds. |
Viz Deconstruct
When Viz deconstruct is enabled, visualizations can be expanded to display their associated dimensions and the number of distinct values for each dimension.
The dimensions table includes the following details:
| Column | Description |
|---|---|
| Dimension | Name of the dimension used by the visualization. |
| Distinct Values | Number of distinct values reported for the dimension. |
If no data is available, Analyzer displays a message indicating that there is no data for this tab.
Sheets
The Sheets tab displays the sheets identified in the application. Use the search field to find a specific sheet.
Each sheet appears as an expandable row containing its name, object count, ownership information, and calculation time in milliseconds. Expand a sheet to view the objects it contains.
The following details are available for each object:
| Column | Description |
|---|---|
| # | Row number in the displayed list. |
| Object Name | Name of the object. |
| Object Id | Identifier of the object. |
| Type | Type of object, such as a KPI. |
| Calc Time | Calculation time reported for the object, in milliseconds. |
| Columns | Number of columns reported for the object. |
| Rows | Number of rows reported for the object. |
| Container | Container information, where applicable. |
Sorting is available for supported columns.
Fields
The Fields tab displays the fields identified in the application's data model. Use the search field to find a specific field. The All fields and Unused only options allow you to view all fields or filter for those identified as unused.
The following details are available:
| Column | Description |
|---|---|
| Field | Name of the field. |
| Table | Table containing the field. |
| Distinct Values | Number of distinct values reported for the field. |
| Memory | Memory attributed to the field. |
| Usage Count | Number of usages detected by Analyzer. |
| Status | Usage status, when available. |
| Used By | Application objects that use the field, when available. |
The usage and memory information helps identify fields that may require further review. Check dependencies before modifying or removing a field.
Tables
The Tables tab displays the tables identified in the application's data model.
The following details are available:
| Column | Description |
|---|---|
| Table | Name of the table. |
| Fields | Number of fields in the table. |
| Rows | Number of rows reported for the table. |
| Memory | Memory attributed to the table. |
Sorting is available for supported columns.
App-Open Progress Log
Select View progress log to open the App-open progress log. It displays events recorded while the application was opening.
The following details are available:
| Column | Description |
|---|---|
| Engine Timestamp | Timestamp associated with the event. |
| Elapsed (ms) | Elapsed time in milliseconds. |
| Type | Event type reported by the engine. |
| Message | Description of the event. |
The log provides additional information about the sequence and timing of app-open events. Close the log to return to the Analyzer results.