Filter that applies to 2 fields

[Pedro_Rodriguez]

Hi all,

Lets say I have this:

Id    Set1    Set2

1      A          B

2                  A

3     B          C

4     A          A 

5     C          D

I'm asked to make a filter that applies to Set1 or Set2, so that if I select 'A' in it, the rows displayed should be:

Id    Set1    Set2

1      A          B

2                  A

4     A          A 

Any ideas?

Thanks a lot in advance.

[Taoufiq_Zarra]

attached qvw file with suggestion

[Pedro_Rodriguez]

Thanks a lot @Taoufiq_Zarra . I was trying something like: 

1) Create a field called Set contaninig all values from Set1 and Set2, outside the table, to be used as the filter's field (I just want one filter)

2) Then create a new field called SetConcat which is Set1|Set2 (belonging to the table)

3) Then created a trigger asociated to selection action in field Set, which selects *Set* in SetConcat

This works fine, just like your solution, but both have the same problem, you just can select one value in the filter for it to work. When you select 2 or more values it doesn´t work

Please see attached

[Taoufiq_Zarra · Accepted solution]

@Pedro_Rodriguez    BINGOOOOOO 🤣

finally I have a proposal that can help you:

the idea in expression :

=if(index(purgechar(purgechar(GetFieldSelections(S1)&GetFieldSelections(S2),','),' '),Set1)>0
or 
index(purgechar(purgechar(GetFieldSelections(S1)&GetFieldSelections(S2),','),' '),Set2)>0
,Set1)

attached the Qlikview file :