topic Re: Organisation Hierarchy in QlikView

Organisation Hierarchy

aveeeeeee7en — Fri, 28 Feb 2014 10:24:30 GMT

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

Re: Organisation Hierarchy

Fri, 28 Feb 2014 10:29:34 GMT

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

Re: Organisation Hierarchy

aveeeeeee7en — Fri, 28 Feb 2014 10:36:13 GMT

Hi Erica

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

Re: Organisation Hierarchy

kumarnatarajan — Fri, 28 Feb 2014 10:39:54 GMT

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

Re: Organisation Hierarchy

Fri, 28 Feb 2014 10:44:36 GMT

hi nag

please find attachment

hierarchy in file

hope this helps you

Re: Organisation Hierarchy

hic — Fri, 28 Feb 2014 10:50:43 GMT

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

Org Chart version 2

HIC

Re: Organisation Hierarchy

Fri, 28 Feb 2014 13:42:53 GMT

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

Re: Organisation Hierarchy

Tue, 29 Apr 2014 19:35:16 GMT

Hi Kumar,

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

regards

sun