topic Re: Related Purchase Chart/table - Qlik Sense in App Development

Related Purchase Chart/table - Qlik Sense

xzerolx86 — Thu, 21 Dec 2023 13:51:17 GMT

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?

Re: Related Purchase Chart/table - Qlik Sense

vincent_ardiet_ — Thu, 21 Dec 2023 15:13:40 GMT

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)>}

Re: Related Purchase Chart/table - Qlik Sense

anat — Mon, 25 Dec 2023 14:27:19 GMT

p() function will work in this scenario.

https://help.qlik.com/en-US/qlikview/May2023/Subsystems/Client/Content/QV_QlikView/ChartFunctions/SetAnalysis/set-modifiers-implicit-field-value-definitions.htm#