Using the Filter Dialog

There are several areas within LityxIQ that make use of the Define Filter dialog box.  This box has a consistent functionality wherever it appears.  This article describes how to use it.

  • Filter Definition - use this box to type in the logical definition of the filter.  This is essentially a code window.  When referring to variable names, enclose them in square brackets.  The result of the code when applied to a record in the dataset should be either a boolean "true" or "false.
  • Include Records - check this box (the default) if the ‘Filter Definition’ you provided describes the records to ‘Keep’ as a result of the filtering process.  Uncheck it if the definition is meant to describe records to ‘Remove’.
  • Fields - this is a dropdown list of variable names that are available.  Use it to help search for variables you want to base the filter definition on.  To insert the selected field into the ‘Filter Definition’, click ‘Insert Field’.
  • Field Values - when you select a field in the Fields dropdown, the Values box populates with possible values stored in the field, or, if it is a continuous field with many values, it will show the min, mean, and max of the variable.  To insert the selected value into the Filter Definition, click either Insert Value or Insert Value with Quotes.  Note that in some cases (for example, the first import of a raw dataset), LityxIQ will not know the possible values of a field and this Field Values box will be un-populated.
  • Insert Operator - this dropdown box shows various logical operators that are available to you as you define the filter. Select one to have it automatically populated into the ‘Filter Definition’ area.
  • Clear - click this button to clear the Filter Definition area.
  • Code Help – click this button to open the Code Help dialog box.  This provides information concerning how to use the various functions available in LityxIQ.