Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys, I am currenlty trying to create a hierarchy, but the end result doesn't show all values, the data comes from 2 tables, please view exmple below:
RID | ParentID | Name |
---|---|---|
123 | Level1 | |
1234 | 123 | Level2 |
12345 | 12345 | Level3 |
123456 | 123456 | Level4 |
1234567 | 1234567 | Level5 |
RID | Person |
---|---|
123 | John Doe |
123 | Jane Doe |
123 | John Doe 2 |
12356 | John Doe 3 |
1234 | Jane Doe 2 |
Now, the hierarchy's data would be populated something like this:
Level1:
John Doe (only displayes 1 person)
Level2:
Jane Doe 2
Level4:
John Doe 3
But I need it to display everything like:
Level1:
John Doe
Jane Doe
John Doe 2
Level2:
Jane Doe 2
Level4:
John Doe 3
If you just create two list boxes, one for Name (Level) and one for Person, and you select Level1, you are not getting 3 possible values: John Doe, Jane Doe, John Doe2 in list box Person?
Have you just linked the tables by RID or have you done something else?
How have you checked your hierarchy? In what chart object with what dimensions / expressions?
Just by RID, yes the hierarchy display correctly, but only problem is it doesn't display everyone.
I checked it in a list box, as tree with delimiter for path '/'
Yes, if I create 2 list boxes, and select level one I do get the persons that are linked to that RID. But it's not displayed in the hierarchy itself.
So how do you create your tree with delimiter '/' from the tables above? Could you upload a small sample .qvw?
Hi Swuehl,
Please find attached, I have scrambled the data because this is a clients data.
Note that I am getting all data from salesforce.