How to use Hierarchy Load (or similar solution)

Wed, 15 May 2013 14:48:20 GMT

Hi,

I heard about the Hierarchy load command and I think is the command I need to solve the follwing question.

The attached table has three Hierarchies, which are the ones that have an empty cell as parent, or , in other words, there is a hierarchy pending of the value 'empty' wich has three 'sons':

CUENTASANUALES

TASAS

ACTIVO

For each of these sons, every element in column 'child' is child of the element in column 'parent'. Some of the childs are only childs but others are also parents of others. At the end all the 'generations' are childs of the empty cell.

Between the empty cell and the very last child can be 3 , 4, 5 or more generations.

I would need to have a hierarchy of fields called for example child, parent1, parent2,.... so the number of fields would be as large as the number of nodes that has the longer generation (I suppose).

I would appreciate an example of how to do this.

Thanks

topic How to use Hierarchy Load (or similar solution) in QlikView

How to use Hierarchy Load (or similar solution)