Alternate States

[parul_mehta]

I have the below set of data

Parent Component	Child Component
N366499	444793-00
N366499	30301914-01
N146358	444793-00
N146358	30301914-01
N146358	30301910-00UM
N147481	444793-00
N147481	30301914-01
N147481	30301910-00UM

I have created two list boxes - Parent Component / Child Component

When I select parent component  N366499 /  N146358 , the intersection values should show in the child component box  ( 444793-00 / 30301914-01 )

Please provide inputs

[Anil_Babu_Samineni]

Can you do this, May be?

Sample:

LOAD [Parent Component],

     [Child Component]

FROM

[https://community.qlik.com/message/1271301]

(html, codepage is 1252, embedded labels, table is @1);

LOAD [Parent Component], Concat('(' & [Child Component] & ')','/') as Red Resident Sample Group By [Parent Component];