Show rows where only all selected filters are present

[francesctesi]

Hi (I am quite inexperienced on qlik view)

I have a table and a filter available on the exam field, as shown in the figure.

I would like,selecting on the filter EXAM = TYPE1 and EXAM=TYPE2, to display only those rows that have both cases, and excluding records that have only one of the two exam types (as shown in the second figure)

[OmarBenSalem]

Put this as a dimension instead of Name:

=if(GetSelectedCount(Exam)=0,Name, aggr(only({<Name={"=count(distinct Exam)=GetSelectedCount(Exam)"}>} Name),Name,Exam))

result :

you select Type1 and Type2 :

[francesctesi]

But this is possibile also in Qlik View? if I have many columns other than "name", how would it change the expression?