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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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!!