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 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.

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.

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.

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.

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?