topic Re: Count Employees divided into groups in QlikView

Count Employees divided into groups

omerbamba — Sat, 16 Nov 2024 03:50:24 GMT

Hey, I have a little complicated problem, I'll try to be as clear as possible.

I manage work groups and employees, for that matter an employee can work in one or more work groups.

I want to build an aggregate table that gathers the workers as follows:
If an employee is work in only one group then it should be written under 1
If employee works in 2 different groups then it will be written under 2

In fact, I want to make sure that most of my employees are in one group and if there are employees who split into several groups, I want to identify them.

I hope I was clear, here's an example:

under dimension:

Re: Count Employees divided into groups

gf — Tue, 16 Apr 2019 14:18:46 GMT

Could you provide some sample data?

Re: Count Employees divided into groups

sunny_talwar — Tue, 16 Apr 2019 14:25:06 GMT

The chart looks like it is doing what you want, isn't it? What is the issue?

Re: Count Employees divided into groups

omerbamba — Wed, 17 Apr 2019 06:22:24 GMT

It turns out that the information displayed there is incorrect

Re: Count Employees divided into groups

omerbamba — Wed, 17 Apr 2019 06:26:19 GMT

Sure,

WT Name, Employee Name

Feeder, Omer

Stacker, Omer

Feeder, Dana

Bronze, John

now it should display,

Number of WT, Number of employees

1 , 2 (Dana and John)

2 , 1 (Omer)

hope you understand now

Re: Count Employees divided into groups

sunny_talwar — Wed, 17 Apr 2019 11:18:06 GMT

What is the correct output? Can you share a sample and provide what you are getting and what you expect to get?

Re: Count Employees divided into groups

omerbamba — Wed, 17 Apr 2019 19:36:55 GMT

The correct output for the data I wrote above:

Number of WT, Number of employees

1 , 2 (Dana and John)

2 , 1 (Omer)

let me know if you understand it now

Thx a lot!