Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Chiclet slicer with multiple True/False fields

I have 2 tables linked via a common ID value.

Table 1 has a set of records to be displayed in a table.

Table 2 has a number of related True/False attribute fields related to Table 1.

 

I need to filter the Table 1 information with a series of True/False buttons (Chiclet slicer with 1 button per T/F attribute) coresponding to each of the True/False attributes in Table 2.

I would like to default to all records (all Chiclets = false) - displaying all rows.

Selecting any of the Chiclets (True) enables filtering to rows containing a true value for the attribute associated with the Chiclet attribute.  Selecting multiple Chiclets applies a logical "AND" to the filter, displaying  any rows containing all rows with true attribute values.

 

I am having trouble configuring the Chiclet Slicer associating multiple fields representing a boolean toggle.

I am also open to other filtering options that do not consume a lot of screen area.

 

Thanks,

Ross