Select related records

[julian_ortiz]

Hi.

Im have one straight table

If I select a value on item_name field, e.g 10, Qlik shows only the records that have 10 (as expected)

Is there a way (expression or script) to show the records that are "related" with 10?, I need to show the barriers related with selected value (image below). 

Thanks in advance

[edwin]

one way i can think of is storing the selected value (assuming user selects only one) in a variable, then in your set analysis,  use the p function to look for all products where item_name (?) = the selected number.

of course you also want to address the scenario where no item_name is selected so you can maybe do that in an if statement testing selected count of item_name

[Digvijay_Singh]

 What do you mean by 'related with 10', the records you have highlighted in red, I don't understand how they are related with 10?

[edwin]

the first exp uses a variable, the other does not