Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
omerbamba
Contributor
Contributor

Count Employees divided into groups

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: Capture.JPGCapture2.JPG

 

Labels (3)
6 Replies
gf
Creator III
Creator III

Could you provide some sample data?
sunny_talwar

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

omerbamba
Contributor
Contributor
Author

It turns out that the information displayed there is incorrect

omerbamba
Contributor
Contributor
Author

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

sunny_talwar

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

omerbamba
Contributor
Contributor
Author

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!