You can associate two query controls. For example, if query control A and query control B are associated, when you select an area in query control A, the province list of query control B displays only the provinces in this area. You can also associate multiple conditions in a query control. This topic describes how to configure conditional cascade to associate query controls.

Prerequisites

  • A dashboard is created.
  • Two query controls are created on the dashboard, with Display Mode set to Drop-Down List (Former "By Value") and Source set to Single Dataset. For more information, see Query data based on a text field.

Background information

When you configure conditional cascade, note the following limits:
  • Upper-level fields can control the display of lower-level fields. However, lower-level fields do not affect upper-level fields. Conditions at the same level can affect each other.
    Note Assume that query fields specified in query control A are area and product_type, and those specified in query control B are province and product_sub_type. If the two controls are associated, when you select an area in query control A, the provinces in the area are selected in query control B. This indicates that fields in query control A are upper-level fields and those in query control B are lower-level fields. All fields in query control A affects query control B. For example, If you select furniture for product_type in query control A, values such as bookshelf and table are displayed for product_sub_type in query control B. However, fields in query control B do not affect query control A.
  • Cascading configuration is not supported on mobile terminals.
  • You can configure up to five conditions for cascading.
  • Conditional cascade is supported only by query controls that have text fields and with Display Mode set to Drop-Down List (Former "By Value") and Source set to Single Dataset.
  • Different query controls may have the same fields. You can modify the value of Control Name for easy identification.Edit the query control name

Open a cascade condition configuration dialog box

  1. Log on to the Quick BI console.
  2. Click the Workspace tab. In the left-side navigation pane, click Dashboards.
  3. Click the required dashboard.
    Note Conditional cascade is supported only by query controls that have text fields and with Display Mode set to Drop-Down List (Former "By Value") and Source set to Single Dataset.
  4. Click the Edit icon icon next to Cascading Conditions.
    Cascading Conditions
You can also click Conditional Cascade Configurationin the Set Query Conditions dialog box.Set Query Conditions
The Conditional Cascade Configuration dialog box appears.Conditional Cascade Configuration page

Configure conditional cascade

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

  1. In the Cascade Configuration Items section, select area and then click the add icon.
    Add a cascade configuration item
  2. Perform the following configurations:

    1. The drop-down list may contain multiple province fields, select the one in query control 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 query control. In this example, the area field in query control A is an upper-level field and the province field in query control B is a lower-level field, and the area field selected is associated with the area field in query control A.
      Associated field
  3. Optional:If you want to configure multiple cascade conditions for query controls A and B, click Add Cascade Configuration Item and repeat steps 1 and 2.
    Cascade configuration items
  4. After the configuration is completed, click Confirm and Return.
    If you select Northwest for area in query control A and select province in query control B, only provinces in northwest China are listed in query control B.area field

Modify the conditional cascade configuration.

You can perform the following operations:

  • 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 the item.2
  • Delete a cascade configuration item.
    Click the Delete icon in the upper-right corner of a cascade condition to delete the condition. Click the Delete icon in the upper-right corner of the cascade configuration item to delete the cascade configuration item.Delete icon