topic Re: Hierarchy load and tree extension in Integration, Extension & APIs

Hierarchy load and tree extension

Wed, 25 Jan 2017 17:33:30 GMT

Hi everybody,

I'm trying to use the D3DynamicTreeLayout-QS extension to create a tree that shows me the hierarchy that is in a table that I load as

Code	Level	Parent code
1234	1	1234
5678	2	1234
9101112	3	5678
13141516	3	5678

I used the Hierarchy function in the load script with the same field (Code) for the node name and for the node ID, but when the data are loaded I find 6 or 7 fields as node name and not only one, does this happen because of the number of data? (I've got 1.2k records).

Also, the extension doesn't work, do you have any idea? Does someone have an example app that uses that extension?

Thanks a lot for your attention

Best regards

Nicolò Cogno

Re: Hierarchy load and tree extension

Gysbert_Wassenaar — Wed, 25 Jan 2017 17:48:43 GMT

I used the Hierarchy function in the load script with the same field (Code) for the node name and for the node ID, but when the data are loaded I find 6 or 7 fields as node name and not only one, does this happen because of the number of data?

Perhaps you should post the script code. Most of us won't have access to your computer or don't know the name of the qlikview document you're working on.

Re: Hierarchy load and tree extension

Thu, 26 Jan 2017 09:18:52 GMT

Hi,

thanks for your help! This is the script that I used:

[HIERACHY_TABLE]:

Hierarchy (CODE, FATHER_CODE, UNIQUE_NAME) LOAD

CODE AS UNIQUE_NAME,

CODE,

FATHER_CODE,

DEPTH_LEVEL

Resident [SCALAR_TABLE];

DROP TABLE [SCALAR_TABLE];

Re: Hierarchy load and tree extension

Fri, 27 Jan 2017 14:08:31 GMT

Does anyone have an example of this? I mean both the data and the app, thanks a lot!!

Re: Hierarchy load and tree extension

girirajsinh — Fri, 27 Jan 2017 15:18:22 GMT

Similar threads with example and apps are there in other posts.

check if this helps you.

Hierarchy in QlikView

Re: Hierarchy load and tree extension

Fri, 27 Jan 2017 15:44:51 GMT

Hi and thanks for your help. I'm reading the attached file

Have you ever used the extension that I mentioned? Because I can't figure out how to use it