Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

INLINE Hierarchy into CrossTable

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:

Capture.PNG

The Load Cross Table:

Capture2.PNG

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

Capture.PNG

Thanks you in advance for your help,

Sébastien.

1 Reply
Highlighted
MVP
MVP

Re: INLINE Hierarchy into CrossTable

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