topic INLINE Hierarchy into CrossTable in QlikView

INLINE Hierarchy into CrossTable

Anonymous — Mon, 23 May 2016 08:20:47 GMT

Hello,

I would like to create into my cross table, used to import data from Excel File, the below load inline to setup a hierarchy between the indicators:

The Inline:

The Load Cross Table:

The final Table, here i would like to create the table Hierarchy here:

Thanks you in advance for your help,

Sébastien.

Re: INLINE Hierarchy into CrossTable

swuehl — Mon, 23 May 2016 08:57:37 GMT

Try to create an INLINE table with pairs of adjacent nodes, parent / child relationsship.

Then use the HIERARCHY and HIERARCHYBELONGSTO LOAD prefixes to create tables that allow to use your hierarchy in a list box tree view as well as dimensions in a pivot table.

Hierarchies