Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
Showing results for 
Search instead for 
Did you mean: 
Not applicable

d3 dynamic tree layout-qs issue

I am trying to make hierarchy chart. I already have 9 hierarchy levels in my table. But it is not working since I don't have depth as a field and when I am trying to use Hierarchy function, it is taking forever to load the data. What should I do? Is there any way to make hierarchy chart without using the hierarchy function? I already have all the data in my table.

1 Reply

Re: d3 dynamic tree layout-qs issue

Hi Apurva,

Use this Formula and will get Depth From this.

Hierarchy(NodeID, ParentID, NodeName, ParentName, NodeName, PathName, '\', DepthNew)

I think u have nodeID,parentID,Nodename,Parent Name

Insert  "PathName, '\', Depth"  as it is you will get Depth automatically.