Need help to understand about Hierarchy and HierarchyBelongsTo with example!

[#1]

Hi All

After going through the help file\reference manual, still I am not very clear about how Hierarchy and HierarchyBelongsTo works in qlikview. Can someone please explain the same with some example in a simple way so that newbie can understand the same. Also it would be great if you can provide some sample document as well.

Thanks in advance!

Regards,

Attitude

[Anonymous]

Hi Attitude,

Hierarchy allows you to build the structure, which allows you to see / locate where is my "selected" position within the tree structure.

For example, if you build an "Employee" hierarchy based on employee vs manager, then you can find who this employee reports to. At the same time, let's say you're trying to find out how many hours you work this week, then you can see the hours comparison amongst:

1. other employees under the same manager; OR

2, other employees under different manager, but still on the same level as you are.

HierarchyBelongsTo allows you to build a structure which allow you to see the total hours of all employees under your manager. Please check out this link, as it helps how I understand it:

http://www.youtube.com/watch?v=ywz8WNitL1k

Cheers,

[kanhomcake]

hi AWQVUser,

I've found that your given link is very useful. It really helps solve my problem

Million thanks for sharing

Regards,

[Anonymous]

Hi Kanhomcake,

Glad to hear that it helps you too

Cheers,

Anton