Using the ibiDataGrid to Filter Other Components

You can select a value from the ibiDataGrid component to filter other data on the dashboard.

With the exception of maps and charts, any component that has an Information Builders filter-enabled property can be used to filter another component.

When ibiDataGrid is set to filter other components, different filter conditions can be applied. By default, the filter condition is set to EQ (equal to). If you select the filter value menu from one of the rows in the ibiDataGrid, it removes the data that is not equal to the value selected and shows only the results equal to the value selected. All of the filter condition operators are supported. For example, if the filter condition property is set to NE (not equal to) in ibiDataGrid, it removes the data of the value selected.

Procedure: How to Use the ibiDataGrid to Filter Other Components

In this procedure, you do not need to specify a condition. The default condition for the grid is EQ, as the filter is applied based on the value of a selected cell in a particular row within a particular column.

Select the Aggregated Grid tab.
Select the SUB02 data grid.
Set the ibiFilterAble property to true.
Run the application, go to the Aggregated Grid tab, and click the Northeast cell. A pop-up menu is displayed.
Click filter Northeast on the menu. The filter is applied to all the grids that have the ibiUseFiltered property set to true.
Click anywhere in the grid. In the pop-up menu you will see another value you can select for filtering. Click Clear all to remove the filters.