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.
| Element | Description |
|---|---|
| Search in | The field in which the search will be made. When entering the dialog it will be set to the field of the active list box. It is possible to change search 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 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 (equivalent to canceling the last Back command). This only possible if the Back 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 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.
| Element | Details |
|---|---|
| Aggregation | In this drop-down it is possible to choose from the statistical aggregation functions available in the QlikView layout. |
| Table | In this drop-down it is possible to select a specific table from which to pick fields in order to make navigation in the Field drop-down easier. |
| Field | This drop-down lists all the fields available. The list may be narrowed down by selecting a specific table in the Table drop-down above. |
| Show System Fields | If this check box is marked, the list containing the fields of the document includes the system fields. |
| Distinct | The statistical functions are by default calculated on the number of occurrences in the original table. Sometimes, however, duplicates are not to be calculated. If this is the case, mark this check box before pasting the function. |
| Paste | Pastes the selected function or just the field into the Search Expression 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.
| Element | Details |
|---|---|
| Function Category | In the drop-down it is possible to select a category of functions in order to make navigation in the Function Name drop-down easier. |
| Function name | In the drop-down it is possible to select a function for pasting into the expression out of all functions available in the QlikView layout. The list can be reduced to show only functions belonging to a certain category by means of a selection in the Function Category drop-down above. |
| Paste | Pastes the selected function name into the Search 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.
| Element | Details |
|---|---|
| Variables | In the drop-down all currently defined variables in the
document are found. Paste Pastes the selected function into the Search Expression edit box. Show System Variables If this check box is marked, the list in the Variables 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.
