Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
pikamaister
Contributor
Contributor

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

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.

Labels (5)
2 Replies
Chanty4u
MVP
MVP

Try this

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

 

pikamaister
Contributor
Contributor
Author

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

Still, much appreciated for the effort !