Creating a filter to display related data

You can create a drop down list of values that when selected displays related information.

To do this, you have to:

  • Build a table component,
  • Build a user input control component, and
  • Create ARRAY and SELECT statements.

Step 1: Building a table component

  1. Select Build a New Klip.
  2. Select the Table component.
  3. Select either the use an existing data source or create a new data source option.
  4. Click Save.
  5. Name the Klip.
  6. Click Finished.

Step 2: Building and configuring a user input control component

  1. Select Build a New Klip.
  2. Select the User Input Control component.
  3. Select either the use an existing data source or create a new data source option.

Goal: Create display options for the drop-down list and values.

  1. From the component tree, select Klip, and type a Klip Title.
  2. From the component tree, select Drop-Down List.
  3. At the Properties panel, provide the required information:

Step 3: Connecting the user input control component with the table component

Goal: Create SELECT statements for the other columns of data.

SELECT( SLICE( B:B ), OR( ( ( Claim_ID = SLICE( A:A ) ) ) , ( Claim_ID = “All” ...) , condition ) )