Related Purchase Chart/table - Qlik Sense

[xzerolx86]

I have a question about chart/table development in Qlik Sense.
I have the following situation.
I have two columns, where one has a purchase code and the other has the product.
Each code can have one or more purchases together.
I need to have a filter, where, filtering by product, you need to bring that product and all other related products that have that same note. Here is a table to illustrate:


After filtering "Banana", it should appear like this:

Can you help me with any suggestion of function or measure to bring this situation into a final table/view?

[vincent_ardiet_]

If you have an expression also in your table (like a sum of quantity, or sum of amount), you can use this set analysis:
{<produto,codigo=p(codigo)>}

[anat]

p() function will work in this scenario.

https://help.qlik.com/en-US/qlikview/May2023/Subsystems/Client/Content/QV_QlikView/ChartFunctions/Se...