topic Re: Employee wise counts in QlikView

Employee wise counts

bhuprakash — Wed, 25 Nov 2020 16:16:04 GMT

Dear all,

I have below data and i want employee wise counts based on date.

Emp Name	Date

A	12/12/2017
A	9/12/2017
B	10/12/2017
C	4/12/2017
C	4/12/2017
C	4/12/2017

so result should be as below -

Emp Name	Counts
A	2
B	1
C	1

Please help me in the same.

Re: Employee wise counts

Anil_Babu_Samineni — Tue, 12 Dec 2017 08:59:16 GMT

May be Count(DISTINCT Date)

Re: Employee wise counts

devarasu07 — Tue, 12 Dec 2017 09:10:52 GMT

Hi,

do u wanted to do in front end or back end?

method 1: using front end

Dimension:

Date

Measure:

count(distinct Date)

method 2: back end script

Emp_Count:
LOAD * INLINE [
    Emp Name, Date
    A, 12/12/2017
    A, 9/12/2017
    B, 10/12/2017
    C, 4/12/2017
    C, 4/12/2017
    C, 4/12/2017
];
join
load [Emp Name],
Count(DISTINCT Date) as EMP_Count Resident Emp_Count group by [Emp Name];

Re: Employee wise counts

bhuprakash — Tue, 12 Dec 2017 09:21:33 GMT

Dear Devarasu,

I am doing it with front end.

Re: Employee wise counts

devarasu07 — Tue, 12 Dec 2017 09:26:19 GMT

Then method 1 & Anil suggestion should work. let us know if u have any issue. tks