Filter multiple Values by Expression

[maxse]

Hey guys I want to filter something special, depending on whether the data is there or not.

You do not know beforehand it will be one or the other combination therefore a kind of double filter:

There are 3 different parts:

Part A
Part B
Part C

If now all three parts are present, only part A and part B should be let through the filter.

But if part B is not there then part A and part c should be let through.

For example, if the database contains only

Part A
Part C

is available.

There are also only the two options,
so either all 3 parts are in, but then only A and B should go through the filter and C not and the second is if B is not there, only A and C should go through the filter.

how can I implement this?

[IraWatt]

Hey @maxse,

I dont fully understand your second example as to what should come out the True if only A and C are present but here is an idea of how to do this:

I just count the number of distinct parts before the filter then change the logic accordingly in the filter (see above/attached).

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com  

[maxse]

That was not the right thing.

Maybe this helps you to understand.

[Christina_H]

I think the solution from IraWatt is working, except for allowing through the wrong two parts in the filter.  You need to change the filter to let through A and C when Count=3, not A and B.
Edit: ignore me, I got myself confused between the Bs and Cs!

[Emmanuel_G]

@maxse 

Do you want something like this ?