topic Re: Org Chart version 2 in QlikView

Org Chart version 2

Brian_Munz — Mon, 26 Jan 2026 16:26:21 GMT

Hi everyone,

I recently helped someone who needed my org chart extension to actually work properly and be less confusing to use (the nerve!).

So, this was a good excuse to quickly update the old org chart extension I built several years ago to make the properties more clear and make the extension more flexible. If I had a lot of time, there's more I'd do, but this should at least be an improvement.

Anyway, I removed all of the properties except for 3:

The path is the same as before. It is the hierarchical tree of employees (or whatever you're displaying) separated by dashes. So an employee named Bill Williams whose bosses are Jim Smith and Fred Clark would be "Fred Clark-Jim Smith-Bill Williams." It's a setting you can choose in QlikView to display as a tree.

Name is the name of the empoyee (or whatever you're displaying). This is needed to properly map and reconcile the boxes with the hierarchy.

The pop up content is where you set what you want to show up in the pop up. This is the main improvement. Before what was shown here was specific, but now you can set it to anything. In order to mimic the pop-up from the extensions example demo (http://us.demo.qlik.com/detail.aspx?appName=Extension%20Examples.qvw) you would set this to be:

=[Employee Desc1] & '<br>' & [Employee Desc2]

So, that's it. No huge changes, but it should be an improvement.

The new extension will not overwrite your old one and will appear as "Org Chart v2"

You can download it here:

http://community.qlik.com/docs/DOC-3892

Thanks!

Re: Org Chart version 2

b_garside — Fri, 17 May 2013 19:42:59 GMT

Tried the new org chart, but the Name field is not rendering the name from path. The blocks are rednering correct based on the Org Path.

Re: Org Chart version 2

b_garside — Fri, 17 May 2013 19:50:01 GMT

also does it wrap text? In Pop up expression

Re: Org Chart version 2

Anonymous — Fri, 26 Jul 2013 11:36:08 GMT

I am having problems implementing this via the Server/Access Point. Through the Deskop in Webview mode I see the Org chart totally correct. If I view the same .qvw file via the Server/Access Point, then I only see the text (content) of the boxes and not the boxes, nor lines nor "+" symbols. See below for printscreens.

In the QMC I have checked the "Allow Extensions" option for the server.

When openning the qvw in Desktop mode, I receive an error message. On clicking upon this, every things displays correctly. When openning the same qvw file in Server/Access Point, I do not get such an error message. The error message is this one:

Any help would be much appreciated.

Re: Org Chart version 2

Anonymous — Fri, 26 Jul 2013 11:51:41 GMT

I forgot to mention that the server and Desktop are running on a Windows 7 Enterprise machine. The Qlikview version is 11.20 SR2 64-bit (non personal) edition (for both the Desktop and Server).

Re: Org Chart version 2

Anonymous — Fri, 26 Jul 2013 12:08:32 GMT

Not meaning to drip-feed, but the Internet Browser I am using is Chrome. But I have also used IE9 with no difference compared to when using Chrome.

Re: Org Chart version 2

Anonymous — Fri, 26 Jul 2013 12:40:35 GMT

and it is SR2

Re: Org Chart version 2

Anonymous — Tue, 30 Jul 2013 06:21:30 GMT

I get the same problem with QV11 SR3. Does anyone have any ideas what is going wrong here?

Re: Org Chart version 2

Anonymous — Wed, 31 Jul 2013 06:44:33 GMT

Well I now have got the Org Charts to work perfectly when viewing it through Access Point. I do not know exactly what I did to make this work. I do still get the error message above when opening the org chart via the desktop in webview.

Re: Org Chart version 2

Wed, 28 Aug 2013 10:49:51 GMT

Hi Brian,

Whenever i try to access the properties of Org Chart i get an error.

Attaching a screenshot of the same.

Please help.

QV Desktop Edition : QV 11.00.11149.0 IR 64-Bit

QV Server Edition :
Product name QlikView Web Server x64
Client Build Number 11.0.11149.0
Target Platform x64

Regards,

Utsav Vachharajani

Re: Org Chart version 2

Tue, 29 Apr 2014 19:38:58 GMT

Hi can anyone give an example of the source data used to load and plot in this Org extension. What data massaging needs to be done to load the data.

Regards

sun

Re: Org Chart version 2

Mon, 05 May 2014 01:53:23 GMT

Morning All,

I've recently used the v2 chart object and resolved an issue encountered in this thread above by Paul. I'll post the solution for anyone using it in the future:

The v2 object installs to your base Extensions/Objects/ directory (v1 Installs under Extensions/Objects/Qlikview/Examples).

The issue with the boxes, lines and the expandable icon not displaying is because the v2 objects main.css directs to the images for v1 (ie :Extensions/QlikView/Examples/org/org_box_parent.png) - so it attempts to locate the directory created by v1 for the images.

Rather than installing v1 as well, you can open main.css and edit the url lines from: /QvAjaxZfc/QvsViewClient.aspx?public=only&name=Extensions/QlikView/Examples/org/

to: /QvAjaxZfc/QvsViewClient.aspx?public=only&name=Extensions/org/

Another issue I encountered was the org chart using hyphens as a seperator (hyphenated names etc), This can be changed by modifying the line var chain = row[0].text.split("-"); in the Script.js file to var chain = row[0].text.split("/"); or another character of your choice.

Hope this helps anyone with similar issues!

Cheers,

Marcus

Re: Re: Org Chart version 2

Mon, 26 May 2014 15:34:06 GMT

PFA the back-end data structure for your reference

Re: Org Chart version 2

Mon, 26 May 2014 15:42:42 GMT

Hi Brian,

Is there anyway to fit this in one screen so that you dont need to scroll. You show org chat more often to senior managers and perhaps scrolling is not the best possible option.

Is there any possibility to breakup the sub-level so that one can see only 3 names in one row ..for example if there are 6 people mapped to Yousuf, first 3 should appear in row 1 and the next 3 should appear in row 2. Perhaps that's one of the possibilities of displaying everything under one window..

Any suggestions on this?

Re: Org Chart version 2

Thu, 14 Aug 2014 08:25:03 GMT

This version looks great (i'm currently on the case to get it added at work), does it allow for dotted lines of management responsibilities?

Thanks,
Caroline

Re: Org Chart version 2

Brian_Munz — Tue, 23 Sep 2014 13:48:58 GMT

Not right now, no.

This is a pretty limited extension, so I'm wondering if in the future someone should built an extension using Google Org Chart.

https://developers.google.com/chart/interactive/docs/gallery/orgchart

Re: Org Chart version 2

Anonymous — Fri, 10 Oct 2014 09:34:25 GMT

Hi marcus..

How to change orgchartv2 saparator - to |..

Please help me..

Regards,

chandini.G

Re: Re: Org Chart version 2

Fri, 10 Oct 2014 12:56:54 GMT

Hi Chandini,

If you locate the org v2 script.js file in your extensions folder (I believe by default, this will be located under C:\Users\User\AppData\Local\Qliktech\Qlikview\Extensions\Objects\Org\script.js). If you have v1 installed as well there will also be a script.js file located under Extensions\Objects\Qlikview\Examples\org\ but you can leave that one alone.

Open this in notepad and scroll down to the line "var chain = row[0].text.split("-"); and change it to your desired character |

Your extension should then split the hierarchy by the new character, if it isn't try creating a test hierarchy using a different character just to verify you're changing the correct file.

Re: Org Chart version 2

Anonymous — Fri, 10 Oct 2014 14:04:02 GMT

Hi Marcus..

Thanks for your reply..

Its help full for me..

can you please find the http://mbostock.github.io/d3/talk/20111018/tree.html this link what is this chart..

can you give me any example Qvw file regarding of this chart..

Thanks,

chandini

Re: Org Chart version 2

ram — Thu, 06 Nov 2014 06:24:25 GMT

Is it possible to have images in the popup content along with the names? Usecase would be a photo of the employee along with other details?