# 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

Expression commands

| Command | Description |
| --- | --- |
| Columns... | Opens the Columns<br>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<br>where you may search for and replace specific text within the current<br>list of expressions. It is also possible to make multiple or bulk changes to the<br>expressions. |
| Export... | Use this button to export the<br>table below to a text file. |
| Apply | Applies changes made in the list<br>back to the properties of the document, sheets and sheet objects, without<br>leaving the dialog. After using this command changes made so far will<br>remain even if you use Cancel<br>to leave the dialog. |
| Edit... | After selecting a single expression<br>in the list you may use this button to open the Edit<br>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) :

Expression columns

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

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