Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.


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


I have a table as shown below:



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!


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