topic Re: Select related records in App Development

Select related records

julian_ortiz — Fri, 07 May 2021 12:41:52 GMT

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

Re: Select related records

edwin — Fri, 07 May 2021 13:13:16 GMT

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

Re: Select related records

Digvijay_Singh — Fri, 07 May 2021 13:21:04 GMT

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?

Re: Select related records

edwin — Fri, 07 May 2021 13:25:06 GMT

the first exp uses a variable, the other does not