Is there a way to use a matching value filter with a single select filter?

Options

Hello!

Currently, the filter control options avaiable for Quick Filter are:

Match value
Single select
Multi-select

Is there a way to use these filter controls together? For example, I may have two columns with the following values:

Name Pets

Ann Cat, Dog, Bird, Reptile
Ben Dog, Bird
Kate Bird, Reptile
Tom Cat
Will Cat, Bird

I added a Match value filter to find all rows that contains "Cat" in Pets, but I only want to select a few of the resulting matches. For example, the match value filter returns:

Cat, Dog, Bird, Reptile
Cat
Cat, Bird

But I only want to select Cat and Card, Bird. Am I able to do this?

I would just do Multi-Select for a simple dataset (such as this example) but unfortunately my dataset may contains up to 100 unique values.

Tagged:

Best Answer

  • GrantSmith
    GrantSmith Coach
    Answer ✓
    Options

    Complex filtering as you're asking isn't currently possible. If you're wanting to select specific values from the list then I'd recommend restructuring your data so that each animal appears on it's own line in your dataset and use a multi-select filter.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓
    Options

    Complex filtering as you're asking isn't currently possible. If you're wanting to select specific values from the list then I'd recommend restructuring your data so that each animal appears on it's own line in your dataset and use a multi-select filter.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**