Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
tamilarasu
Champion
Champion

Hierarchy table based on selection

Hi,

I have 3 fields and their names are Node, Parent and Position. I have to create a hierarchy table based on user selection and the selection can be anything in the list.

Capture.PNG

I can't edit load script (this one is sample) because it was already created, so have to adjust through expressions.

Can someone help me.

Thank you in advance.

Kind Regards,

Tamil

2 Replies
tamilarasu
Champion
Champion
Author

At least let me know is this possible or not.

Not applicable

It is not difficult, if you do select in field [HierarchyTable.KUNNR] instead of [%HIERARCHYLINK]. Expressions are:

=only({<HierarchyTable.HIERARCHY_POSITION={'500'},%HIERARCHYLINK={"=HierarchyTable.KUNNR"}>}%HIERARCHYLINK)

=only({<HierarchyTable.HIERARCHY_POSITION={'400'},%HIERARCHYLINK={"=HierarchyTable.KUNNR"}>}%HIERARCHYLINK)

=only({<HierarchyTable.HIERARCHY_POSITION={'300'},%HIERARCHYLINK={"=HierarchyTable.KUNNR"}>}%HIERARCHYLINK)

=only({<HierarchyTable.HIERARCHY_POSITION={'200'},%HIERARCHYLINK={"=HierarchyTable.KUNNR"}>}%HIERARCHYLINK)

=only({<HierarchyTable.HIERARCHY_POSITION={'100'}>}HierarchyTable.KUNNR)

Capture.PNG