topic Re: Hierarchy table based on selection in QlikView

Hierarchy table based on selection

tamilarasu — Tue, 20 Jan 2015 06:40:03 GMT

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.

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

Re: Hierarchy table based on selection

tamilarasu — Thu, 22 Jan 2015 06:22:19 GMT

At least let me know is this possible or not.

Re: Hierarchy table based on selection

Thu, 22 Jan 2015 09:08:26 GMT

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)