Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

ektarathi
New 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

Re: Need Help building a Pivot table

Hi,

Please check the qvw attached.

Hope it helps.

Regards,

Jemimah

2 Replies
Not applicable

Re: Need Help building a Pivot table

Hi,

Please check the qvw attached.

Hope it helps.

Regards,

Jemimah

ektarathi
New Contributor III

Re: Need Help building a Pivot table

Hi Jemimah,

That works!!Thank you so much!!

I also tried something using advanced aggregation in pivot table, even that worked :-)

Community Browser