How to get Days worked and total employee

[bhuprakash]

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 -

Region	Emp Name	Worked Date	Activity Code
SA-II	A	1/12/2017	ACT1
SA-I	C	5/12/2017	ACT2
SA-II	A	2/12/2017	ACT3
SA-II	A	3/12/2017	ACT4
SA-II	B	1/12/2017	ACT5
SA-I	C	6/12/2017	ACT6
SA-I	C	6/12/2017	ACT7
SA-I	C	6/12/2017	ACT8

and I want result set in below format-

SBU	Days Worked	Total Employee
SA-I	2	1
SA-II	3	2

Please help me in the same. Thanks.

[Or]

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

[Anonymous]

Use aggr() function in expressions

[devarasu07]

Hi,

Try to do below steps,

Create below dimension:

Region

Measure:

Days Worked

count(DISTINCT [Worked Date])

Total Employee

count(DISTINCT [Emp Name])

[bhuprakash]

Thanks a lot Devarasu. You are great

[devarasu07 · Accepted solution]

Hi,

Can you close this thread by marking as correct. Tks