Filter control on multiple fields

Q&A
, ,
1

Hi! I want to create a control filter on 2 fields from my dataset: Carrier 1 and Carrier 2. By default it should show all carriers. When I will select one OR MORE (that’s important) I want to show all records that have e.g. carrier BG in carrier 1 or carrier 2 - kinda something that is shown in the picture. I managed to obtain some functionality with parameter SelectedCarrier (default single value - All) and calculated field:

ifelse(
    {CARRIER_1} = ${SelectedCarrier} OR {CARRIER_2} = ${SelectedCarrier},
    1,
    0
)

And then filter on this field - equals 1. But this allows me only to select just one carrier. If nothing selected it shows ‘No data’.

obraz
obraz2322×1000 84.5 KB

2

Hi @JRoz, you actually don’t need to create a calculated field for this. Clicking on the “Add filter condition” button allows you to add another filter to the existing one in OR condition. You can use this mechanism to create two OR’ed filters, one for carrier 1 and the other for carrier 2, both using the common carrier parameter tied to the control.

Below is an example from my environment. Some some random alphabetical codes are used for carrier 1 and 2. As you can see, I can choose multiple values in the control and the rows containing the selected carrier codes in either carrier 1 or carrier 2 are returned in the table.

image
image888×791 45.3 KB

Let me know if this solves your problem.

3

Wow that’s clever thank you so much :slight_smile: