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

Announcements
FLASH SALE: Save $500! Use code FLASH2026 at checkout until Feb 14th at 11:59PM ET. Register Now!
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

Labels (1)
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