6.2.1 Defining Simple Conditions

Simple conditions are conditions defined on the pre-aggregate data, that is, before any grouping or summarization. Simple conditions are always joined together using the 'AND' operator. To gain greater flexibility, you can use advanced conditions; see Defining Advanced Conditions.

Note: Filtering conditions are only applied to data that is retrieved from the database. The amount of data (number of rows) retrieved is determined by the 'Max Rows' setting and the global 'Design mode sample data size' setting. See Previewing a Table and Showing Live Data in a Table for more information.

To define a simple condition, follow these steps:

1. Click the 'Condition' button on the title bar of a Data Table. This opens the 'Condition' dialog box.

 

2. Click the 'More' button to specify a new condition.

3. Use the menus in the 'Edit' pane to define the condition. See Filtering Operators for details on the options.

4. Click 'OK' to save the condition and close the dialog box. Click 'Modify' to update the condition without closing the dialog box.

5. To delete a condition, select the condition in the list and click the 'Fewer' button.

If the condition you specify references data model attributes that do not already exist in the table, these attributes are automatically added to the table as invisible columns.

Example: Defining Simple Conditions  >>

Say you have a table listing the total sales of products grouped by their categories, and you wish to view only those categories that have yielded total sales of at least $1,000,000.

1. Create a new Worksheet.

2. Expand the 'Data Source' node, and the 'Orders' node.

3. Drag the 'Sales by Category' query on to an empty cell in the Worksheet. This creates a new table named 'Sales by Category1'.

4. Click on the 'Condition' button located in the upper right corner of the table's title bar. This will open the 'Conditions' dialog.

5. Click on the 'More' button to create a new condition.

6. Select 'Total Sales' from the drop-down list on the left.

7. Select 'greater than' from the operator drop-down list and check the 'or equal to' check box to add the 'greater than or equal to' condition.

A Variable or another field value can be used in the condition by selecting 'vari­able' or 'field' and specifying either the Variable or the field name. See Creating a Variable for more information.

8. Specify “1000000” for the value.

 

9. Click on the 'OK' button.

10. Right-click the table title bar, and select 'Preview' from the context menu.

 

 

<< 6.2 Filtering © 1996-2013 InetSoft Technology Corporation (v11.5) 6.2.2 Defining Advanced Conditions >>