To find the topmost Parent

Tue, 23 Sep 2014 10:53:17 GMT

Hi All,

Can someone help me out here..

I have 2 fields Child_ID and Parent_ID.. Need to find the topmost Parent.

I have no idea whether to use Loops or Hierarchy.

Please find the attachment for the example with explanation:

Child_ID	Parent_ID
1	2
2	3
3	7
4	5
5	10
6	11

To Find:

Topmost Parent of Child_ID 1

Process to find:

"When I choose 1 in Child_ID, its corresponding parent_ID is 2 and 5. Again when I search 5 in Child its corresponding parent is 10. When I search 10 in child_id again it is not found in Child_ID. Hence the Topmost parent of 1 would be 10.

In similar way when I search for 2 in Child its corresponding parent is 3. when I search for 3 in child_id its parent is 7. when I search for 7 in child_id again it is not found in Child_ID and thus, topmost parent for 1 is 7 also."

Result:

For Child_ID 1 the topmost Parent_ID would be 7 and 10

Re: To find the topmost Parent

vikasmahajan — Tue, 23 Sep 2014 11:00:50 GMT

YOU NEED TO CREATE HIERARCHY LOAD PLEASE FIND EXAMPLE

Hierarchy belong to script error

Hierarchy belong to script error Hierarchy in QlikView

May help you.

VIKAS

topic To find the topmost Parent in App Development

To find the topmost Parent

Re: To find the topmost Parent