Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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?
the first exp uses a variable, the other does not