Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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