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: 
Not applicable

Filter after multiple selection

Hi guys,

I have a table containing the purchase detail. Every row has a purchase order ID (header info) and its related purchase item.

Let's assume the table is like this.

PurchaseOrderID     PurchaseItem

1                              A

1                              B

2                              C

3                              C

3                              D

Is it possible to get the below result after I select item A and D?

PurchaseOrderID     PurchaseItem     Reason

1                              A                      Because it matches with A

1                              B                      Because it relates to PurchaseID=1

3                              C                      Because it relates to PurchaseID=3

3                              D                      Because it matches with D


Thanks in advance.

Roy

1 Solution

Accepted Solutions
sunny_talwar

May be a set analysis like this

{<PurchaseOrderID = p({<PurchaseItem = p(PurchaseItem)>} PurchaseOrderID), PurchaseItem>}

Capture.PNG

View solution in original post

2 Replies
sunny_talwar

May be a set analysis like this

{<PurchaseOrderID = p({<PurchaseItem = p(PurchaseItem)>} PurchaseOrderID), PurchaseItem>}

Capture.PNG

Not applicable
Author

Hi Sunny,

Thank you for the help, it worked!!