Multi Select Filter Not working On ALL Clauses

Question

Hello,

I have enabled a filter widget and SQL Expression Builder clause set. To get multiple selections I've used "is any of" and 'Values filtered by all other expressions".

But when implemented I get strange behaviors. The first clause allows selecting multiples but others act differently. When I select the second clause the choices disappear after the first pick. However if I can click really quickly, I can sometimes get multiples. My other dashboards using other data work as designed. See below.

GregReinecke · Answer

It seems this behavior only appears when the SQL Expression Builder clause option is set to either "Values filtered by previous expressions" or "Values filtered by all other expressions".  But if you set these clause options and can click check boxes very fast you can get sometimes get multiple selections but if you click normally often the selection just wants to minimize allowing only a single checkbox to be checked.

Thanks.

MOSTAFAAZIZKHANI · Answer

I have a similar issue with SQL Expression Builder in ExB.

GregReinecke · Answer

Thank You @TonghuiMing. I will see if I can sanitize some data and post the app. This doesn’t happen on my other ExB dashboards. Interesting.