Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
prabhu0505
Valued Contributor

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
Contributor III

Maintain Hierarchy

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
Valued Contributor

Maintain Hierarchy

Thanks alot for your reply.

I will go through and update you.

prabhu0505
Valued Contributor

Maintain Hierarchy

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
Valued Contributor

Maintain Hierarchy

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

Maintain Hierarchy

Hi Saravana,

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

Not applicable

Maintain Hierarchy

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
Valued Contributor

Maintain Hierarchy

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

Maintain Hierarchy


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
Valued Contributor

Maintain Hierarchy

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