You can associate two filter bars. For example, if Filter Bar A and Filter Bar B are associated, when you select an area in Filter Bar A, the province list of Filter Bar B displays only the provinces in this area. You can also associate multiple filters in the same filter bar. This topic describes how to configure conditional cascade to associate filter bars.

Prerequisites

Usage notes

  • Upper-level fields can control the display of lower-level fields. However, lower-level fields do not affect upper-level fields. Fields at the same level can affect each other.
    Note For example, query fields specified in Filter Bar A are area and product_type, and those specified in Filter Bar B are province and product_sub_type. If the two filter bars are associated, when you select an area in Filter Bar A, the provinces in the area are selected in Filter Bar B. This indicates that fields in Filter Bar A are upper-level fields of fields in Filter Bar B. All fields in Filter Bar A affect fields in Filter Bar B. For example, if you select furniture for product_type in Filter Bar A, values such as bookshelf and table are displayed for product_sub_type in Filter Bar B. However, fields in Filter Bar B do not affect those in Filter Bar A.
  • A maximum of five cascading conditions can be configured.
  • You can configure conditional cascade only when filter bars contain text fields, Display Type is set to Drop-down List, and Option Source is set to Single Dataset.
  • Different filter bars may contain the same fields. For the purpose of easy identification, you can modify the value of Control name in the Basic Settings section. Edit the filter bar name
  • If a filter in a filter bar is hidden, the cascade configuration is retained only when the filter is at the first level. In other cases, the cascade configuration is cleared.
  • The following results occur if you hide the first-level filter after you configure conditional cascade:
    • Values that can be selected from the sub-level filters are determined based on the default values specified in the first level.

      For example, if you use the area > province > city > county cascade condition and the value of Set Filter Defaults in the first-level filter is Southeast, values that can be selected from city or county are from provinces in southeast China.

    • If you do not configure Set Filter Defaults for the first-level filter, values that can be selected from the sub-level filters are determined based on global parameters.
    • If you do not configure Set Filter Defaults or global parameters for the first-level filter, the first-level filter does not take effect. In this case, values that can be selected from the sub-level filters are all the valid values. Configuration example
    • If you configure both Set Filter Defaults and global parameters for the first-level filter, values that can be selected from the sub-level filters are determined based on global parameters.

Go to the conditional cascade configuration page

  1. Log on to the Quick BI console.
  2. Choose Workspace > Dashboards.
  3. Click the required dashboard.
    You can configure conditional cascade for a filter bar only when the filter bar contains text fields, Display Type is set to Drop-down List, and Option Source is set to Single Dataset. 1
  4. In the Page Settings pane, click the Edit icon icon next to the Cascading Conditions section.
    1
You can also click Conditional Cascade Configuration in the Set Query Conditions dialog box. Conditional Cascade Configuration
The Conditional Cascade Configuration dialog box appears. Conditional Cascade Configuration

Configure conditional cascade

For example, the query fields specified in Filter Bar A are area and product_type, and those specified in Filter Bar B are province and product_sub-type. After the area and province fields are associated, when you select an area in Filter Bar A, the province list of Filter Bar B displays only the provinces in this area.

  1. In the Cascade Configuration Items section, select the area field and then click the Add icon.
    Add a cascade configuration item
  2. Perform the following configurations:
    1. Select a field that you want to associate with the area field.
      The drop-down list may contain multiple province fields. You must select the one in Filter Bar B. 1
    2. Select an associated field.
      Note The associated field refers to a field in a dataset. The field is associated with the area field in the filter bar. In this example, the area field in Filter Bar A is an upper-level field and the province field in Filter Bar B is a lower-level field, and the area field you selected is associated with the area field in Filter Bar A.
      Associated field
  3. Optional:If you want to configure multiple cascade conditions for Filter Bars A and B, click Add Cascade Configuration Item and repeat steps 1 and 2.
    Cascade configuration items
  4. After the configuration is complete, click Confirm and Return.
    If you select Northwest for area in Filter Bar A and select province in Filter Bar B, only provinces in northwest China are listed in Filter Bar B. area field

Modify the conditional cascade configuration.

You can perform the following operations to modify the conditional cascade configuration:

  • Rename a cascade configuration item.
    When you add a cascade configuration item, the default name is Cascade Configuration Items. You can click it to rename it. 2
  • Delete a cascade configuration item.
    You can click the Delete icon in the upper-right corner of a cascade configuration item to delete it. You can also click the Delete icon in the upper-right corner of the cascade configuration item to delete it. Delete