CheckBoxGroup to Filter a table?

I have a table connected to a query - it has a list of fruits/vegetables and their associated color.

I have created a CheckBoxGroup control that is connected to the table - with the options being different colors.

So I could check 'orange' and the table will filter all fruits/vegetables that are that color.

However, it only works when I have one option selected, but not when I have more than one.

I cant select Orange and Yellow and get a list of fruit that is either color.

This is how I have the control setup:

it seems like it's doing an AND and not an OR?

Any ideas?

Hello @dbFolsom,

Your issue might be related to the default operator in the table:

You can switch it to "Or" in the table settings.

If that doesn't work you might have to play around with setting filter stacks, but this should fix it.

It is also helpful to look at the table state to see what might be wrong in cases like this:

image

Let me know if this helps!

1 Like