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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! 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

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