Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
ciampaciampa
Contributor III
Contributor III

Indirect Set Analysis and List Box

Attached a picture that explains the problem.

I use a P() set analysis expression for answering to a query that requires an intersection between two sets.

The count calculation is correct.

Problem: The list box shows all the values while I want to show only the selected values by the expression (in this case just one - the "id1").

(Actually, I solved the problem using the Aggr() ("Interceptor" in the picture) but I don't like it as the Aggr() is a very resource consuming)

How to solve in a way more elegant and efficient?

Thanks

1 Reply
sunny_talwar

If you want to use set analysis, then Aggr() might be the only solution... I can't think of a way to avoid the use of Aggr()