Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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

 

6 Replies
gf
Contributor II

Re: Count Employees divided into groups

Could you provide some sample data?

Re: Count Employees divided into groups

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

omerbamba
New Contributor

Re: Count Employees divided into groups

It turns out that the information displayed there is incorrect

omerbamba
New Contributor

Re: Count Employees divided into groups

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

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

omerbamba
New Contributor

Re: Count Employees divided into groups

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!