Filter and Sort

In each table in easymap it is possible to set filters on single columns or achieve a desired sorting of data.

For a filter (or a changed sorting) simply click on the column heading and you will get a menu for selecting the filter function.

Note: Please remember that this type of filter is only a view filter and does not create a new table. So, if an analyses is created on such a table, the analyses will use the entire data set of this table and not only the filter set by you. If a reduced number of data is required, please create this data quantity using a query.

Filter and sorting options in the tables

If you click on the column heading, a context menu appears in which you can sort the column in ascending or descending order, view the statistics for this column, or call up additional filters.

Sort Ascending sorts the table in ascending order based on the data from the selected column. (available in the context menu of External Data, Queries, Geographical Data and Analysis Results)
Sort Descending sorts the table in descending order based on the data from the selected column. (available in the context menu of External Data, Queries, Geographical Data and Analysis Results)
Statistics Provides you with information on the number and the most frequently used term/value.
Delete filter off [Column name] Deletes the filter from the specified column.
Text Filters / Number filter

Allows filtering based on the entered value or name:

  • Corresponds to...
  • Does not correspond...
  • Starts with...
  • Ends with...
  • Contains...
  • Does not contain...
  • User-defined filter...
Filter [name of the selected column]. Filter By Selection

Lists all data records based on a base cell that have the same cell content as the base cell in the column. The base cell is the cell on which the corresponding context menu for the filter is opened.
  By Inverted Selection Shows all data records except those that have the same cell content as the base cell in the column. The base cell is the cell on which the corresponding context menu for the filter is opened.
  Filter by With Filters by you can search exactly for the term or value.
Column [Name of the selected column]. View Displays the selected column as a data value, bar, or color value.
  Hide Hides the selected column in the table.
  Freeze Fixes the table to the selected column to be able to compare it directly with columns further back.
  Unfreeze
  • Cancels an existing fixation.
    		•
      Rename
  • Allows you to assign a new name to the column.
    		•
    Link table and map...

    Opens a selection window for linking of tables and maps. The coupling is done via a column of the table and the appropriate layer of the map. The assignment statistics can be used to see how many data sets are assigned to an area and how many areas receive a data set. (available in the context menu of External Data and Queries)

    properties Here you can also access the Properties of the table columns.

    Edit Calculated Column [Name of Selected Column]...

    Allows the subsequent editing of previously calculated columns.

    Delete calculated column [name of selected column]...

    Allows you to delete previously added columns.