topic Maintain Hierarchy in QlikView

Maintain Hierarchy

prabhu0505 — Wed, 12 May 2010 06:33:21 GMT

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...

Maintain Hierarchy

spsrk_84 — Wed, 12 May 2010 08:19:39 GMT

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

Maintain Hierarchy

prabhu0505 — Wed, 12 May 2010 08:22:05 GMT

Thanks alot for your reply.

I will go through and update you.

Maintain Hierarchy

prabhu0505 — Wed, 12 May 2010 10:40:06 GMT

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

Maintain Hierarchy

prabhu0505 — Thu, 13 May 2010 05:28:01 GMT

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

Maintain Hierarchy

Thu, 13 May 2010 05:45:07 GMT

Hi Saravana,

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

Maintain Hierarchy

Thu, 13 May 2010 06:12:21 GMT

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 |

Maintain Hierarchy

prabhu0505 — Thu, 13 May 2010 07:18:52 GMT

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..

Maintain Hierarchy

Thu, 13 May 2010 07:43:29 GMT


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.

Maintain Hierarchy

prabhu0505 — Thu, 13 May 2010 08:03:46 GMT

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

Maintain Hierarchy

Thu, 13 May 2010 09:58:48 GMT

Hi,

Still you can use the Rikab suggetion.
your code should be as follow


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

and you do the following changes in listbox property.

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

Hope this may help you.

- Peterson

Maintain Hierarchy

prabhu0505 — Thu, 13 May 2010 13:39:13 GMT

Hi Kevin,


 Load Sr.Manager,
if
(Designation1 = 'Sr.Manager', Designation1 )&'|'
&
if
(Designation1 = 'Manager',Designation1 )&'|'
&
if
(Designation1 = 'Department Head',Designation1 ) &'|'
&
if
(Designation1 = 'Team Lead',Designation1 ) &'|'
&
if
(Designation1 = 'Associates',Designation1 ) as Hierarchy,
Manager
 as Manager,
[Department Head]
 as DepHead,
[Team Lead]
 as TLead,
Associate as Asso
RESIDENT
items;

I tried this code but it is giving error.

Please go through my code and suggest me.

Thanks for your continuos support...

Prabhu