Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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 :
But this is possibile also in Qlik View? if I have many columns other than "name", how would it change the expression?