Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
prabhu0505
Specialist
Specialist

Maintain Hierarchy

If I select a particular department, then the table box or chart should list the employees of it in a hierarchical way.

Say,

Sr. Manager, Manager, Department Head, Team Lead, Associates..........

Thnx...

11 Replies
spsrk_84
Creator III
Creator III

Hi Saravana,

To create an employee hierarchy or Deoartment hierrarchy use the function like

Hierarchy and HierarchyBelongs To

Using these functions u can create the Hierarchy...

For u reference if u have instaleed Qv9 there is an example file name "What New in Qv 9.Qvw" in examples .In this Sales Rep hierarchy is created like SalesRep-Manager-Superior like this..

Refer the above example stated hope that will help you in achieving ur required task.....

Regards,

Ajay

prabhu0505
Specialist
Specialist
Author

Thanks alot for your reply.

I will go through and update you.

prabhu0505
Specialist
Specialist
Author

I have gone through the example but this was not what I expected.

Sorry I need to bit more specific,

Sr. Manager, Manager, Department Head ....

are not fields but value of the field Designation

I hope this help.

Advance Thanks

prabhu0505
Specialist
Specialist
Author

I have gone through the example but this was not what I expected.

Sorry I need to bit more specific,

Sr. Manager, Manager, Department Head ....

are not fields but value of the field Designation

I hope this help.

Advance Thanks

Not applicable

Hi Saravana,

Can you attach your QVW file so that we can work on with that.

Not applicable

Try this:


new:
Load Sr.Manager
Sr.Manager &'|'& Manager&'|'& Department Head &'|'& Team Lead &'|'& Associates as Hierarchy,
Manager as Manager,
Department Head as DepHead,
Team Lead as TLead,
Associates as Asso
RESIDENT items;


Also don't forget to do the following things.

List Box --> Properties --> Tick "Show as treeview" --> With seperator |

prabhu0505
Specialist
Specialist
Author

Thanks Rikab..

I have a doubt in your example:

whether Sr.Manager, Manager, Department Head...... are fields or value in items table (My expectation is that it should be value)

Advance Thnx..

Not applicable


Saravana Prabhu wrote:
I have a doubt in your example:
whether Sr.Manager, Manager, Department Head...... are fields or value in items table (My expectation is that it should be value)<div></div>


It is a field not a value. That's why I asked for your QVW application. So that I can see why you need hierarchy of a value instead of field.

prabhu0505
Specialist
Specialist
Author

Sorry Rikab.

Due to some reason, I can't share that file.

Anwsering to your question:

According to me its value of the field "Designation1"

My objective is to achieve the hierarchical order while displaying any object like list box or table box or chart.

Thanks

Prabhu