How to use "Qlik-Sense-D3-Tree-Layout"

[ysakurayama]

Hi mhamano-san

My name is Yohei Sakurayama. I have a question about your "Qlik-Sense-D3-Tree-Layout".

To use your Extension, I create a following form excel file. And load it.

-NodeID -ParentID -NodeName -Measure 1 1 A 1 2 1 B 1 3 1 C 1

And I create a chart by "Qlik-Sense-D3-Tree-Layout" Use these 3 Dimensions(NodeID,ParentID,NodeName) and Measure(use "Sum()").

But coludn't create chart. Showed "Error failed Visual Rendaling".

I have a mistake how to create chart? Please tell me how to use.

[mhamano]

Hi Yohei,

Just leave the ParentID of the top node empty, and it will work fine. (In your sample data, the top node is referencing to itself as a parent node.) The following is a sample load script:

Load * Inline [ NodeID,ParentID,NodeName,Measure 1,, A, 1 2, 1, B, 1 3, 1, C, 1 ]

[ysakurayama]

mhamano-san

Thanks.I can solve my probrem.

And I have another question.

I tried following data.

NodeID,ParentID,NodeName,Measure 1,, A, 1 12, 1, B, 1 13, 1, C, 1 2,, A, 1 22, 2, B, 1 23, 2, C, 1

Can't use 2nd parents node?

[mhamano]

Hi Yohei,

This extension works only for a tree with one top node. When there are multiple top nodes, please place a dummy top node on the top of them.

[ysakurayama]

Hi mhamano-san

Thanks your replay. I try it.

[mogina]

I can't see the visualization after defining my data well

[vamanj]

Hi mhamano-san ,

i have taken the source code(Excel file) as

NodeID | ParentID | NodeName | Measure |   1 |   | A | 10 |   2 | 1 | B | 20 |   3 | 1 | C | 30 |   4 | 1 | D | 40 |   5 | 1 | E | 50 |   6 | 1 | F | 60 |  

But am not getting the visualization The issue am getting is NOde name is showing in red color only please find the below screen shot

[SihemSam]

Hi, I have the same error, did you find any answer? Maybe it's working on Qlik sense server only, I am using qlik sense desktop.

[Juriell]

Hi. I have the same problem - only level 1 is displayed. when i load data from excel, qlik sense replaces null with "-". could this be a problem?

[ahsyed]

Hi mhamano-san, I have an issue with the D3-Tree-Layout-qs chart. It works differently in different environment. For example, in one instance the default view with the parent and child node for the chart shows up and in another, it does not. ie. the chart is blank unless I select any value from the filer. The Data is same for both the instances. Please suggest what may be the factor.

Thanks - Syed

[vamanj]

Hello mhamano-san/friends,

yes i got achieved this by changing the java script code for this extension, i have done some changes in the script level. In java script level there we have one more tab called "Hidden Node Name" , so i have un-commented that & used that in my chart(instead of hidden name used Hidden Node name in chart level).

if still you are getting the same then try to change the " Depth " to "Depth2" i have changed that in Data Load editor. and use that in you chart level

Thanks