Organisation Hierarchy

[aveeeeeee7en]

Hi Guys

I have a requirement to show Company Hierarchy in Graphical way.

I have tried so many Solutions but none of them are Perfect ones.

I have also used Hierarchy and Hierarchy Belongs To Function but no Good Results.

If someone has a better solution than please give suggestions or workarounds???

Regards

Aviral Nag

[#2]

Hi Nag

Once you've loaded the hierarchy in, probably the quickest and easiest way to do this is using a list box and the "treeview" function for the "pathsource" column in the expanded nodes table.

This is the table where there is one column for each level, and then the pathsource column is the one separated by "/"

EG vicepresident/headofsales/saleslead/salesperson

Set this as the listbox, tick the box marked treeview and use "/" as the separator

Otherwise you may wish to look at using QlikView extension objects, although there are workarounds possible

Erica

[aveeeeeee7en]

Hi Erica

I have used Hierarchy Function but as I said I need Graphical form for it.

[kumarnatarajan]

Hi,

I think you need extension,

See the below URL:

http://mbostock.github.io/d3/talk/20111018/tree.html

you can intagrate in qlikview this d3 chart.

Else use pivot table or scatter chart this should help you.

Hierarchy  is best function for you result

[#5]

hi nag

please find attachment

hierarchy in file

hope this helps you

[hic]

There is an Org Chart extension for QlikView. See more here

Org Chart version 2

HIC

[#7]

hi Nag

What I was saying is the list box (an ordinary list box) is the easiest way to do it - you just have the list box for pathsource column, set it to tree view separated by "/".  then you get a basic hierarchy in the list box (although not ideal - extensions would be much better, like the one posted by Henric below)

Erica

[#8]

Hi Kumar,

  Do you have an example of the integration in QV you have mentioned above.

regards

sun