topic Re: D3.js and JSON input in QlikView

D3.js and JSON input

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

Hi All,

Anyone dealed with d3.js and json input ? I'm doing some research using d3.js to build a tree node view. I've found a sample, here,D3.js Drag and Drop, Zoomable, Panning, Collapsible Tree with auto-sizing. but reviewing the code it read the data from a json format dataset.

I'm newbie in javascript programing and json, then I suppose I need to create a function to read QV.Data.Rows and converts it to json format. Any clue on how to do it ?

Best Regards,

Pablo Labbe

Re: D3.js and JSON input

Nicole-Smith — Thu, 27 Feb 2014 18:44:37 GMT

//Declaring a two-dimensional array (an array of arrays)
var input = new Array(this.Data.Rows.length);

//Getting the data from QlikView
for (var j = 0; j < this.Data.Rows.length; j++) {
     input = this.Data.Rows[0].text;
}

//Changing the array into a hierarchical json
var output = [];
for (var i = 0; i < input.length; i++) {
     var chain = input.split("/");
     var currentNode = output;
     for (var j = 0; j < chain.length; j++) {
          var wantedNode = chain;
          var lastNode = currentNode;
          for (var k = 0; k < currentNode.length; k++) {
               if (currentNode.name == wantedNode) {
               currentNode = currentNode.children;
               break;
               }
          }
     // If we couldn't find an item in this list of children
     // that has the right name, create one:
          if (lastNode == currentNode) {
               var temp = wantedNode.split('} ');
               var newNode = currentNode = { id: wantedNode, name: temp[1], children: [] };
               currentNode = newNode.children;
          }
          }
}
var json = output;

Re: D3.js and JSON input

pablolabbe — Thu, 27 Feb 2014 20:44:55 GMT

Nicole,

Many thanks for this piece of code. A great starting point. I'll test it as soon as possible.

Best Regards,

Pablo

Re: D3.js and JSON input

Thu, 17 Jul 2014 16:07:37 GMT

Hello Pablo,

I was also looking for a way to bring this chart into Qlikview and I came across your post
D3.js Drag and Drop, Zoomable, Panning, Collapsible Tree with auto-sizing.

Have you had any success in bringing this chart into Qlikview using the above code as yet? If so, then how did you achieve it? Any help would be greatly appreciated. Thanks

Regards

Mohd

Re: D3.js and JSON input

Mon, 10 Nov 2014 23:49:23 GMT

hi Pablo Labbe

does the extension work based on this code? could i get the qar? my email is : chriszhang345@hotmail.com

Thanks

Ani