Qlik Community

QlikView Documents

Documents for QlikView related information.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

HIERARCHY - DESCRIPTION

thiago_mlg
Not applicable

HIERARCHY - DESCRIPTION

HIERARCHY

I would like to share with you the knowledge that perhaps many have not yet used, however at some point is inevitable, HIERARCHIES of NODE tables. Talking to several people developing in QlikView most of them do not know this concept, even by not using, put in some companies, including using SAP you'll surely come across this kind of concept. Tables hierarchies that are structured in us, that is, FATHER and SON. For that use within the QlikView HIERARCHY command that transforms a FATHER / SON table in a useful table in QlikView.

To be able to work this method the table should be structured as shown below.

CAMPO PAI = FATHER FIELD

CAMPO FILHO = FIELD SON

DESCRIÇÃO DO NÓ = NODE DESCRIPTION

This table behind FATHER information, SON and DESCRIPTION KNOT through this table, which is usually used in ERPs like SAP, TVTOS among others will put generate a usable table. For this, the command should be used as follows.

TABELA_HIERARQUIA:

Hierarchy (FIELD SON, FATHER FIELD, NODE DESCRIPTION)

LOAD

     SON FIELD,

     FIELD FATHER,

     DESCRIPTION KNOT

FROM TABELA_HIERARQUIA

When this function is performed will have the following result:

It maps all we create the parent table and child until your last level, as shown below.

Thus it is possible aplicas these levels PivotTables and charts, involving much of the time the other tables to create cash accounts tables, financial items and even departmental structure.

Hope this helps.

Thiago Gonçalo

Labels (2)
Attachments
Comments
msteedle
Not applicable

I think this post did a very good job explaining them: Hierarchies in QlikView « BI Commons

Version history
Revision #:
1 of 1
Last update:
‎03-19-2015 10:00 AM
Updated by: