Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Association between fields of a table and selecting them

Hi,

I have a table as shown below:

 

Field1Field2
AB
BC
DC
EF
GF
GH
IH

A in field1 is an equivalent to B in Field2 and B in Field1 is an equivalent to C in Field 2 and similarly D in field1 is an equivalent to C in field2.

If I create 2 list boxes for field1 and field2, and if I select value A in listbox field1, I want the values A (in listbox field1), B(in listbox field2 and listbox field1), C in (in listbox field2 and listbox field1) and D (in listbox field1) to be selected automatically since A,B,C,D are equivalent to each other. I have tried using triggers and select possible function but it is not able to perform as stated above.

Any help will be appreciated!

Thanks!

1 Reply
MVP & Luminary
MVP & Luminary

Re: Association between fields of a table and selecting them

Ok, that's a bit tricky. Basically you have a hierarchy where you want to select the top node A and then select all the descendants as well. For that you need to remodel your data to build the necessary hierarchy tree. You can use the HierarchyBelongsTo function for that. See this blog post for an example: Unbalanced, n-level hierarchies


talk is cheap, supply exceeds demand