Multi-Select Items from table to only display what has "ALL" items selected.

[pikamaister]

Hi Fellow Users,

I have an interesting requirement from my team that I am not sure how to solve within Qlik, maybe someone else found a solution?

I have two tables in my data structure:

1. First table is unique based on order_id and has many side-details.
2. Second table also has and order_id however that is not unique, as it also has a Feature column, and each new row for the same order_id contains a new value in the Feature column.

These two tables are joined together on order_id for easy filtering.

For one order_id there is about 200-300 features, and there is 1M+ orders, creating all possible combinations is not feasible. I would like to create a filtering logic that allows me to multi-select features, and filter down only the products that have ALL the features selected. 

Ex: Filter for Products that has Feature (1) and (2)

Order_ID	Feature
A	1
A	2
A	3
B	1
B	4
B	5
C	1
C	2

Result:

Order_ID

A

C

If you have any idea how to solve this, please tell me because i've been at it for a while and still don't see a way ahead.

[Chanty4u]

Try this

=Aggr(If(Count({<Feature=>} Distinct Feature) = Count(Distinct {<Feature=>} Feature), Order_ID), Order_ID)

[pikamaister]

Sadly doesn't work, it still returns every order_ID which has either of the two filtering options 😕

Still, much appreciated for the effort !