Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pulling my hair out over Recursive Hierarchy issue.

Hi,

I don't have much experience with the Hierarchy function, so was wondering if someone could give me any pointers/help.

Basically I have an Item, which is the main ID(FITEM), which is made up of other Items(CITEM), which in turn may be made up of other Items. etc etc. CITEM.

In my case I have FITEM-5002227, which is made up of Items underneath it, one being 200813.

200813 has 4 Items underneath it, 2 of those Items then have Items underneath them...so on and so forth.

Basically I'm trying to achieve this recursive structure, to show this Hierarchy in a chart table.

I've had a look at the manual, viewed other related posts and played around with the Hierarchy function, but I think I'm going around in circles.

I've attached a sample of what I'm working on.

Any help would be appreciated!

Xena

6 Replies
Not applicable
Author

Xena,

I hope the attached sample helps a bit.

I used Regions instead of items for (at least for me) better readability.

Best,
Thilo

Not applicable
Author

Thanks Thilo!Smile

I'll be able to achieve what what I'm looking for using this example.

Not applicable
Author

Hi,

I'm on the right track, but not sure how to get the very Top Level to show all Item's underneath.

I've attached an example with a chart table having Item 5002227 which has Items underneath it, one being 200813

Then 200813 should have Items underneath it and some of those Items have items etc etc.....

My chart should look something like :

5002227>200813 >750330>903930 (in this case the lowest item)

>item. >item...

>item

How could I get this to show in my example .qvw?

Thanks!

Not applicable
Author

Hi,

Hope you are looking for this only

L1 L0 ParentID1 ID Expression
50022272008137503309039301
7503319039301
-50022272008135003941
5003951
7503301
7503311
-50022272008131
4550321
4908811
5400421
6051851
6400081
6500031
6944261
50022251


Rahul

Not applicable
Author

Thanks Rahul!

This is great.

marcohadiyanto
Partner - Specialist
Partner - Specialist

hi.. i want to ask about hierarchy,

any solution, if i wanna create hierarchy when ChildID and ParentId have the same id?