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: 
bhuprakash
Creator II
Creator II

How to get Days worked and total employee

Dear All,

I am stuck at one place as i am beginner to Qlikview. Please help in the get the data as below.

Note : I am doing this in Front end.

I have data in below format -

    

RegionEmp NameWorked DateActivity Code
SA-IIA1/12/2017ACT1
SA-IC5/12/2017ACT2
SA-IIA2/12/2017ACT3
SA-IIA3/12/2017ACT4
SA-IIB1/12/2017ACT5
SA-IC6/12/2017ACT6
SA-IC6/12/2017ACT7
SA-IC6/12/2017ACT8

and I want result set in below format-

   

SBUDays WorkedTotal Employee
SA-I21
SA-II32

Please help me in the same. Thanks.

1 Solution

Accepted Solutions
devarasu07
Master II
Master II

Hi,

Can you close this thread by marking as correct. Tks

View solution in original post

5 Replies
Or
MVP
MVP

Looks like Count(Distinct [Worked Date]) and count(Distinct [Emp Name]), but I may not understand what you're trying to do.

Anonymous
Not applicable

Use aggr() function in expressions

devarasu07
Master II
Master II

Hi,

Try to do below steps,

Create below dimension:

Region

Measure:

Days Worked

count(DISTINCT [Worked Date])

Total Employee

count(DISTINCT [Emp Name])

Capture.JPG

bhuprakash
Creator II
Creator II
Author

Thanks a lot Devarasu. You are great

devarasu07
Master II
Master II

Hi,

Can you close this thread by marking as correct. Tks