topic Re: Visualization of Graph Data in QlikView

Visualization of Graph Data

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

Hi all,

I started to develop an extension for graph visualization based on the Graph Dracula Library, using Raphael: http://www.graphdracula.net

This seems to be an interesting topic. First of all, what is the best data representation of graph data in a relational QlikView world? Second, there are a lot of limitations using those JavaScript libs. I've tried some before (D3.js etc.) but Dracula seems to have the simplest interface for my use case.

What is your opinion?

- Ralf

Re: Visualization of Graph Data

rbecher — Sun, 03 Feb 2013 17:54:45 GMT

Hi all,

this is an overhauled version of the extension. I've changed the labeling and added nodes color control for better visualization.

- Ralf

Re: Visualization of Graph Data

Anonymous — Thu, 05 Dec 2013 10:23:55 GMT

Hi Ralf,

That's a great extension to use.

I have few questions, could you please help me out here.

1.Could you help me define on how many second nodes are to be plotted. Like for one movie, if I have more then 100 actors, I would like to plot only the 100 actors and not plot the others.

2.I see that there is a tool tip function already defined in the script, could you help me call that function. What i am looking for is to provide additional information in the tooltip, like the total sales, etc.

Thanks in advance,

Aadil.

Re: Re: Visualization of Graph Data

rbecher — Thu, 05 Dec 2013 11:31:44 GMT

Hi Aadil,

thanks. Do you mean to have max. 100 second nodes at all or max. 100 child nodes by parent node? The second case would be much more complex. You would need to build a temp array to store the amount of child nodes by parent node during the rendering and skip if max. amount is reached. I think this is a good idea and I will make some more thoughts on it for this version.

I'm working on a new version for a while which will have node selection possibility and also switches node size on a threshold of 50 nodes to prevent to get too crowded. It has tooltip also.

Click a Node to select a Node additive.

Use Alt-Click to clear selection and select a new Node (best to select Child Nodes).

Use Ctrl-Click for dragging Nodes.

You can play around with it but the developement is not really finished yet.

- Ralf

Re: Visualization of Graph Data

Anonymous — Thu, 05 Dec 2013 12:23:00 GMT

Thanks for the quick response Ralf.

I sure will look into this.

Thanks again,

Aadil

Re: Visualization of Graph Data

rbecher — Mon, 17 Feb 2014 17:18:01 GMT

Now I have developed another graph extension based on Sigma.js (www.sigmajs.org). This is a first version you can play with:

The graph drawing is much faster now. However it is more complicated to get a useful graph layout. I'm still working on this.

- Ralf

Re: Visualization of Graph Data

Tue, 04 Mar 2014 04:28:38 GMT

Dear Ralf,

Apologies for my naivety but pl help me out. I want to know if the SigmaGraph.qar is an extension to QlikView that I can use for visualization in a new QlikView chart with a neo4J data. Or is it specific to this example that you have loaded. If so can you pl tell us how to do similar for the ones we wish to do.

Sorry once again for the trouble and naivety.

Regards,

Karthik

Re: Visualization of Graph Data

rbecher — Tue, 04 Mar 2014 08:41:27 GMT

Dear Karthik,

yes, SigmaGraph.qar is an object extension you can use in QlikView, for free. You can adapt the example to your data. That means you have to set the extension dimensions and measures to your fields in the properties dialog.

Regarding Neo4j data, the example uses our product JDBC Connector to connect Neo4j graph database and to execute Cypher queries to retrieve data from nodes and edges of the graph.

Regards,

Ralf

Re: Visualization of Graph Data

Tue, 04 Mar 2014 22:22:26 GMT

Hi There Ralf. May I ask you for a favor, please? Would you mind listing the version of the Neo4J software you are using to get your SigmaGraph App (2/17/14) to function properly? I would really love to see this app in action.

For my part, I downloaded the zipped Cineast data, your QV SigmaGraph qvw and SigmaGraph.qar, the Neo4j Server (2.0.1) and the corresponding Neo4J JDBC Drivers. After trial and error (version compatibility errors), I set allow_store_upgrade=true in the neo4j.properties file and removed the '?' symbols from the queries in the QV Script to get the data to load without errors. Everything loaded - except for the Actor/Director list box. So, I am not able to view the graph. Any ideas? Have you tried your QV Sigma App with the newer Neo4J releases?

Thanks in advance, Tai.

Re: Visualization of Graph Data

rbecher — Tue, 04 Mar 2014 22:47:39 GMT

Hi Tai,

indeed, the LOAD script part was developed with an older Neo4j version, I guess it was v1.7. I need to overhaul it a bit.. However, if you download the QVW file and install the extension you will not need to reload the data. You can just see how the SigmaGraph.qar extension will work.

If you're really interested to use our JDBC Connector to retrieve data from Neo4j v2 we have to setup a test case. Just drop me a line: ralf.becher@tiq-solutions.de

- Ralf

Re: Visualization of Graph Data

Thu, 20 Mar 2014 04:21:06 GMT

Hi Ralf,

Can you please attach the Document with explanation. That one will very much helpful for me

Re: Visualization of Graph Data

Mon, 16 Jun 2014 10:33:34 GMT

Hi Ralf,

Thanks for a really nice extension! One question; are there any limits on how many nodes and child nodes the extension can plot? When will it become difficult to use?

Best regards

// Marianne

Re: Visualization of Graph Data

rbecher — Mon, 16 Jun 2014 11:15:37 GMT

Hi Marianne,

I set the limit to 2000 lines for the extension in Definition.xml. This means it will paint 2000 edges maximum, theoretically 4000 nodes max. I guess it will get very slow with more then a hundred nodes or so because of the auto layout rendering (GraphDracula). For the SigmaGraph extension I used a circular layout which is much faster. But we could provide a more cusotmized version if needed..

- Ralf

Re: Visualization of Graph Data

Tue, 17 Jun 2014 09:30:31 GMT

Thank you Ralf!

Re: Visualization of Graph Data

phaneendra_kunc — Sun, 03 Aug 2014 05:17:49 GMT

Hello Ralf,

This is a great extension to plot hierarchical data. one thing i am not able to figure out is to replace the "ellipse" with image.

Can you let me know how can i use images instead of "ellipse" as nodes.

Thanks

Phani

Re: Visualization of Graph Data

rbecher — Sun, 03 Aug 2014 08:40:48 GMT

Hi Phani,

I guess you have to deep dive into the code of the extension and used library to find a solution.

- Ralf

Re: Visualization of Graph Data

Thu, 14 Aug 2014 14:26:43 GMT

Hi Ralf, it´s a great extension!

I have one Question: I´m using this addon on an own dashboard and I´m having the following issue in runtime:

I guess it can be a compatibility problem... I´ve installed QlikView Personal Edition v11.20.12235.0 SR5 for 64bit running on Windows 7.

Could you tell me which versions of QlikView supports this addon?

Thanks in advance!

- Martin

Re: Visualization of Graph Data

rbecher — Thu, 14 Aug 2014 14:40:34 GMT

Hi Martin,

I cannot say what this issue is related to. The extension itself should work with your QlikView version. Maybe you can upload your QVW file here so I can check if it's related to the data or something else.

- Ralf

Re: Re: Visualization of Graph Data

Fri, 15 Aug 2014 13:40:09 GMT

Hi Ralf,

Attached the QVW file. It's A POC... I also was thinking that perhaps the issue is related to Internet Explorer version. it can be possible?

thank you very much

- Martin

Re: Visualization of Graph Data

rbecher — Fri, 15 Aug 2014 14:50:55 GMT

I cannot reproduce this issue but had some negative effects with the container object. Please try extension outside of container object..