# Advanced Search dialog

The Advanced Search dialog provides a convenient way of formulating complex search queries to be applied on QlikView fields. Unlike the standard search box that appears when starting a search by typing when a list box is active, the result of the search is not interactively visible in the layout until submitting the search by pressing the Go button. The dialog can be kept open while working in the QlikView layout. The dialog is fully sizeable in order to facilitate editing of large and complex expressions.

Search dialog elements

| Element | Description |
| --- | --- |
| Search in | The field in which the search will be made. When entering the dialog<br>it will be set to the field of the active list box. It is possible to change search<br>fields by using the drop-down at any time. |
| Search Expression | This is where the search expression is typed. The same rules apply as when using<br>the normal search box. |
| Go | Applies the search to the search field |
| Back | QlikView remembers the last 100 selections. Click this button to go one step back in the list of selections. |
| Forward | Click this button to go one step forward in the list of selections<br>(equivalent to canceling the last Back<br>command). This only possible if the Back<br>command has been used immediately before. |
| Clear Field | Clears selections in the current search field. |
| Clear All | Clears all selections in the document |
| Help | Opens the Help dialog for advanced<br>search. |
| Close | Closes the dialog. |

The the pane with three tabs at the bottom of the dialog can help you when you build advanced search expressions.

## Fields

Select the Fields tab to access controls for pasting syntax relating to QlikView field data.

Field tab elements

| Element | Details |
| --- | --- |
| Aggregation | In this drop-down it is possible to choose from the statistical aggregation functions<br>available in the QlikView layout. |
| Table | In this drop-down it is possible to select a specific table from which to<br>pick fields in order to make navigation in the Field<br>drop-down easier. |
| Field | This drop-down lists all<br>the fields available. The list may be narrowed down by selecting a specific<br>table in the Table drop-down<br>above. |
| Show System Fields | If this check box is marked,<br>the list containing the fields of the document includes the system fields. |
| Distinct | The statistical functions<br>are by default calculated on the number of occurrences in the original<br>table. Sometimes, however, duplicates are not to be calculated. If<br>this is the case, mark this check box before pasting the function. |
| Paste | Pastes the selected function<br>or just the field into the Search Expression<br>edit box. A percentage can be given when using the fractile function. |

## Functions

Select the Functions tab to access the controls for pasting syntax relating to QlikView general functions.

Functions tab elements

| Element | Details |
| --- | --- |
| Function Category | In the drop-down it is possible to select a category of functions in order to make<br>navigation in the Function Name<br>drop-down easier. |
| Function name | In the drop-down it is possible to select a function for pasting into the expression<br>out of all functions available in the QlikView layout. The list can be<br>reduced to show only functions belonging to a certain category by means<br>of a selection in the Function Category<br>drop-down above. |
| Paste | Pastes the selected function name into the Search<br>Expression edit box. |

At the bottom of the dialog there is a pane showing the argument syntax of the function selected in the Function Name drop-down.

## Variables

Select the Variables tab to access the controls for pasting syntax relating to QlikView variables.

Variable tab element

| Element | Details |
| --- | --- |
| Variables | In the drop-down all currently defined variables in the<br>document are found.<br>Paste<br>Pastes the selected function into the Search<br>Expression edit box.<br>Show<br>System Variables<br>If this check box is marked, the list in the Variables<br>drop-down will include the system variables. |

At the bottom of the dialog there is a pane showing the current value of any variable selected in the Variables drop-down.