topic Re: Extension for making selections with tree diagram/organisation chart in Integration, Extension & APIs

Extension for making selections with tree diagram/organisation chart

mc19qlik — Tue, 06 Nov 2018 11:41:37 GMT

Hi all, I'm looking for an extension which allows you to make selections based on a tree diagram.

I've found extensions like this D3 Dynamic Tree (https://github.com/mhamano/Qlik-Sense-D3-Tree-Layout) which is ideal other than the fact that you can't click on nodes to make a selection using these properties.

Even something like this Organisation chart based on Google Chart Org Chart (https://github.com/yianni-ververis/google-organizational-chart) but this doesn't allow clicking either.

Is anyone able to advise on whether they know of any extensions with this sort of capability? I'm using Qlik Sense if that matters.

Thanks

Re: Extension for making selections with tree diagram/organisation chart

mek — Tue, 06 Nov 2018 16:40:09 GMT

This might work for you: https://github.com/miralemd/mekaarogram

Re: Extension for making selections with tree diagram/organisation chart

mc19qlik — Tue, 06 Nov 2018 16:58:07 GMT

That's exactly what I'm after. However, when I add the extension into my Qlik Sense and populate with Dimensions and a measure, I get an error of 'The visualisation failed to render'.

Any advice? The dimensions are just categories of items and the measure is just a count of the number of items using a unique ID.

Otherwise this is exactly what I was looking for.

Re: Extension for making selections with tree diagram/organisation chart

mek — Tue, 06 Nov 2018 17:25:07 GMT

The extension uses some internal Qlik Sense modules which may not work in older Sense versions, which Sense version are you using?

Re: Extension for making selections with tree diagram/organisation chart

mc19qlik — Wed, 07 Nov 2018 10:05:13 GMT

I'm in Qlik Sense 12.36.1 I think, I downloaded a new version relatively recently.

Re: Extension for making selections with tree diagram/organisation chart

mc19qlik — Thu, 08 Nov 2018 12:12:21 GMT

It seems to work intermittently without me changing anything? Any ideas?

Re: Extension for making selections with tree diagram/organisation chart

mek — Wed, 14 Nov 2018 11:48:33 GMT

It's very possible that it is interfering with another extension - do you have any of those?

Re: Extension for making selections with tree diagram/organisation chart

mc19qlik — Wed, 14 Nov 2018 11:58:54 GMT

Yeah I have a bunch actually. Do you think they interfere if they're in the same app or just in the same sheet?

Re: Extension for making selections with tree diagram/organisation chart

mek — Wed, 14 Nov 2018 12:06:46 GMT

They could interfere if you're viewing them during the same browser session, i.e. if you open a sheet with another extension that loads or does something they are not supposed to, and then switch to a sheet with the mekaarogram on it - when it loads it could be interfering with something already loaded or done by another extension.

In order to find the issue you could have one extension per sheet, and then go back and forth between the sheets with other extensions and the sheet containing the mekaarogram - you should reload the browser between every attempt in order to get a clean slate.

Re: Extension for making selections with tree diagram/organisation chart

mc19qlik — Wed, 14 Nov 2018 12:22:02 GMT

Interesting, in hindsight it did break having put a new extension in. However, now if I open a fresh instance of Qlik Sense Desktop, create a new app, load my data, and only put the mekaarogram in, it still fails to render? I realise what I'm saying is quite difficult to offer advice on without being able to directly edit what I'm doing. Can you suggest anything else I could try?

Re: Extension for making selections with tree diagram/organisation chart

mek — Wed, 14 Nov 2018 12:37:36 GMT

Hmm, the only thing left I could think of is the Sense Desktop version you're running

Re: Extension for making selections with tree diagram/organisation chart

mc19qlik — Wed, 14 Nov 2018 12:41:21 GMT

Out of curiosity was it developed using Qlik Sense Cloud? I've just run QS Desktop through my browser and it works

Re: Extension for making selections with tree diagram/organisation chart

mek — Wed, 14 Nov 2018 12:58:29 GMT

Ahh, if it works in the browser but not in the native QS desktop then the issue is most likely an old browser version. Qlik Sense Desktop uses its own browser (Chromium), you could check which version if you open up dev tools and running navigator.userAgent .

Re: Extension for making selections with tree diagram/organisation chart

mc19qlik — Wed, 14 Nov 2018 13:40:00 GMT

Running that, I get this (if it makes any sense to you):

navigator.userAgent
"Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/47.0.2526.16 Safari/537.36 USC/1.0"

Re: Extension for making selections with tree diagram/organisation chart

mek — Thu, 15 Nov 2018 07:57:13 GMT

Ouch, that's a Chrome version that is almost 3 years old - didn't think of that.

Has the extension ever worked in Qlik Sense Desktop?
Has the extension ever failed in Qlik Sense Enterprise? Which version?

Re: Extension for making selections with tree diagram/organisation chart

mc19qlik — Thu, 15 Nov 2018 11:33:23 GMT

It worked on one day last week but there didn't seem to be any reason for it. It started working suddenly and then stopped the same day. That was in Qlik Sense Desktop, version 12.something (listed in a previous comment).

I haven't used Qlik Sense Enterprise, to get it to work I just booted Qlik Sense Desktop in my Chrome browser (using http://localhost:4848/hub/) , which has the version 'Version 70.0.3538.102'. I've also shared it with friends who are using Chrome and it worked for them. One did mention that they initially tried to open it in Edge and that didn't work. They told me that Edge version was 'Microsoft Edge 41.16299.726.0'.

Re: Extension for making selections with tree diagram/organisation chart

mek — Wed, 23 Jan 2019 11:12:17 GMT

So, I finally got around to probably fixing the issue with mekaarogram not working in QS Desktop and IE, just had to change a few thousand lines of code :). v0.8.1 should work better https://github.com/miralemd/mekaarogram/releases

Re: Extension for making selections with tree diagram/organisation chart

mc19qlik — Wed, 23 Jan 2019 11:14:09 GMT

Thanks very much, really appreciate your efforts!