Expression Overview

This dialog shows all document, sheet and sheet object expressions in a single list. From this list you may edit single expressions or do Find/Replace on multiple expressions. Select one or more expressions from the list. A selected line appears in black. Click below the last expression to deselect it.

In the top left hand corner of the dialog you can select more than one check box.

  • Chart Expressions

  • Chart Attributes

  • Color Expressions

  • Show Conditions

  • Other Expressions

Columns... Opens the Columns dialog where you may customize which columns should appear in the Expression Overview dialog. The Expression column cannot be turned off.
Find/Replace... Opens the Find/Replace dialog where you may search for and replace specific text within the current list of expressions. It is also possible to make multiple or bulk changes to the expressions.
Export... Use this button to export the table below to a text file.
Apply Applies changes made in the list back to the properties of the document, sheets and sheet objects, without leaving the dialog. After using this command changes made so far will remain even if you use Cancel to leave the dialog.
Edit... After selecting a single expression in the list you may use this button to open the Edit Expression dialog for the selected expression.

The expression list in the lower part of the dialog may contain the following columns, based on settings in the Columns dialog (see below) :

Sheet ID The sheet ID of the sheet where the expression occurs. Empty for document expressions.
Sheet Name The name (tab title) of the sheet where the expression occurs. Empty for document expressions.
Object ID The sheet object ID of the sheet object where the expression occurs. Empty for document and sheet expressions.
Object Name The name of the object where the expression occurs.
Location The location of the expression within properties with 'friendly name', i.e. a simple explanation of the type of expression.
Label The label of the main expression of the object.
Location (Full) The exact location of the expression within the properties structure. The notation corresponds to the object property hierarchies of the QlikView Automation interface, which is explained in detail in the QlikView API Guide.
Expression The expression definition.

Changes made from this dialog can be undone by the regular Undo command.

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?