Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Hierarchy / Parents

Hi all,

i have a problem with a table that i LOAD and i want to restructure. The source table looks somewhat like follws:

LocationIDLocationNameParentLocationDepth
1World
0
2Europe11
3America11
4Africa11
5South America32
6Eastern Europe22
7Sao Paolo53
8Moscau63

What i want is:

LocationIDLocationSubLocationIDSubLocationSubSubLocationIDSubSubLocationSubSubSubLocationIDSubSubSubLocation
1World2Europe6Eastern Europe8Moscau
1World3America5South America7Sao Paolo
1World4Africa----
























Can someone help ?

Thanks a lot!

3 Replies
Gysbert_Wassenaar

Here's a simple example using the hierarchy function to create a hierarchy table.


talk is cheap, supply exceeds demand
Not applicable
Author

Thanks, but i need result table like the one i sketched...

Not applicable
Author

Hi Phillipe,

You can try using a cross table,you can achieve the format :

LocationIDLocationSubLocationIDSubLocationSubSubLocationIDSubSubLocationSubSubSubLocationIDSubSubSubLocation
1World2Europe6Eastern Europe8Moscau
1World3America5South America7Sao Paolo
1World4Africa----

Hope this helps.

Rochelle