topic One filter for two fields (select if one has the value) in QlikView

One filter for two fields (select if one has the value)

Pedro_Rodriguez — Sat, 16 Nov 2024 19:14:22 GMT

Hello,

I have a table like this:

Id Ran1 Ran2

1 12 24

2 12

3 17 20

4 24 14

I need one filter with all possible values of Ran1 & Ran2 where, if I select x values, it applies to Ran1 or Ran2. For instance, if I select in that filter values 12 and 14, I would get:

1 12 24

2 12

4 24 14

I've tried creating a new field concateneting Ran1&Ran2 with a delimiter, and using a trigger that selects ='*'&RanFilter&'*' in that concatenated field. But this doesn't work when I select more than one value.

Any ideas?

Tanks!

Re: One filter for two fields (select if one has the value)

Taoufiq_Zarra — Sat, 25 Jan 2020 13:35:18 GMT

attached 😁

Re: One filter for two fields (select if one has the value)

Brett_Bleess — Wed, 19 Feb 2020 21:32:30 GMT

Pedro, did Taoufiq's post and example apps help you with your use case? If so, please be sure to return to your thread and on his post, use the Accept as Solution button to mark that as the solution giving him credit for the help and letting other Members know this worked. We do expect our Members to close out their threads if possible, especially if they have received posts. If you did something different, please consider posting that and then mark that post, and if you need further help, leave an update.

Regards,
Brett