Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ektarathi
Contributor III
Contributor III

Need Help building a Pivot table

Hi All,

I need some help building a pivot table. I have some employee data, with person id(means employee id), Name(means employee name), Country(this is the country where employee works from), supv person id(employees supervisor id) etc. Since one supervisor may have many employees reporting to them, 'supv person id' may be same for different employees.I need to build a table which says how many supervisors have 1 employee reporting to them(also said as direct reports), how many supervisors have two direct reports, how many have three and so on. And this should also work with Country that we select. Please find an example below for how this should work. This is very urgent request. Any help would be greatly appreciated.

Please let me know in case anything is not clear in my example. Thanks!


Untitled.png

1 Solution

Accepted Solutions
Not applicable

Hi,

Please check the qvw attached.

Hope it helps.

Regards,

Jemimah

View solution in original post

2 Replies
Not applicable

Hi,

Please check the qvw attached.

Hope it helps.

Regards,

Jemimah

ektarathi
Contributor III
Contributor III
Author

Hi Jemimah,

That works!!Thank you so much!!

I also tried something using advanced aggregation in pivot table, even that worked 🙂