The Objects sheet provides an inventory of QlikView objects, sheets and expressions. Objects can be sorted by type and by labels, definitions and by
Sheets and objects
The Object Counts chart in the Sheets & Objects section presents the total number of each type of object. When there are no current selections, Object Count is the total from all files on the scan date indicated.
When one or more files from File Name is selected, the object count represents the total of each type of object in the selected
The Sheets, Objects, Expressions table presents objects and expression labels organized by the
The Sheet column shows only
Objects are sorted by type and then by Object ID. Multiple instances of a single
Label lists the labels for each of the expressions.
Definition shows the definition for each expression and variable. For dimensions, the definition is the field name or calculated dimension. For groups, the definition is cyclic or drill (hierarchic). For List boxes, the definition is the expression or field for the box. For a text object, the definition is the text entered in the text box.
The QVW Object Summary table provides overview data for each
The Expressions section provides an inventory of expressions and labels and associated variables.
The Labels with Multiple Expressions bar chart can be used to sort on labels with varying numbers of expressions. When a single label is used to display the results of different expressions, confusion can arise, especially if the label is used multiple times in a single
The Expressions with Multiple Labels bar chart can be to sort on expressions with varying numbers of labels. When a single expression is used by different labels, important relationships might be missed because the results are displayed under different labels.
The Expressions table presents the total number of times each expression occurs, the number of labels that use the expression, and the number of
Selecting an expression cross-references the labels that use the expression and the
The Expression Labels table presents the total number of times each label occurs, the number of lxpressions or definitions that use the label, and the number of
Selecting a label cross-references the expressions used by the label and the
The Variables table presents each variable name and its definition and the number of labels that use it.
Selecting a variable cross-references the labels and expressions that use the variable and the
The Field Usage section provides a summary of all places where the literal text of a field name is found in expressions, labels, variables, dimensions, and field groups. With this information, a QlikView developer or administrator can quickly get a sense of how much and where different fields are used within and across QlikView apps, which is particularly important when performing an impact analysis related to the change or removal of a field or group of fields from an application.
Each of the charts on this page uses an expression pattern to identify places where the literal text of the field name exists. The pattern
if(index(Item,QVWFieldName)>0,' ',0) references the specific Item defined by the given chart name.
The Expressions table shows the location of the literal text string for each field in the expressions within an application.
The Labels table shows the location of fields referenced in labels. A label is defined primarily for charts, list boxes, and sheets.
The Variables table shows the location of fields explicitly referenced in user-defined and system-defined variables.
The Dimensions table shows the location of fields used as dimensions for charts.
The Groups (Dimensions) table shows the cyclic or drill-down dimension groups in which the field is contained.