topic Hierarchical data issue in QlikView

Hierarchical data issue

Anonymous — Sun, 08 Feb 2015 20:19:57 GMT

Hi everyone,

Have an issue that I can't figure out. In the attached spreadsheet is a list of names of employees for a company. It lists each employee, the employee's manager, the manager of the employee's manager, and so on, up to the title of President of the company. What I want to do is count the number of employees whose title is 'Worker' for each Vice President. Based on the hierarchy, the Vice President could be in the Mgr, Mgr+1, or Mgr+2 columns of the file.

In the example provided, Karen Wilson should have a total of 3 workers, and Paula Jones should have a total of 4. I can split this info up into different straight tables based on the Mgr, Mgr+1, or Mgr+2 fields, but I want to have a single table that shows Karen Wilson and her count of 3, and Paula Jones and her count of 4. Any ideas?

Re: Hierarchical data issue

Peter_Cammaert — Sun, 08 Feb 2015 20:38:42 GMT

When LOADing the spreadsheet, add a column called VicePresident to every row. It will contain a name if anyone of the three Manager columns contains a VicePresident (3 nested IFs will be sufficient)

Then create a Straight Table with field Vice President as single dimension, and the following expression:

=count({<Title = {"Worker"}>} DISTINCT Employee)

Re: Hierarchical data issue

Anonymous — Mon, 09 Feb 2015 06:40:42 GMT

Hola,

PFA.

HTH