I have to show a list of the field "Houses" that satisfies ALL the criteria selected in field "Criteria". Using the default qlik associative model, it shows me "Houses" that satisfy one or more of the selected criteria. Hence I used some custom code posted by another user in this community to use an "AND" selection instead of "OR" selection.
However, it now does show me the correct number of houses that satisfy ALL the criteria, using AND logic. It also shows me the correct name of the houses, but the names appear to be grey, i.e. they are not selected. How do I appear to make them white, i.e. selected?
if( match( getselectedcount(Criteria), aggr(count( distinct Criteria ), Houses )), Houses)