topic Re: looking for OT in QlikView

looking for OT

Paknanarn23 — Fri, 15 Nov 2024 21:36:11 GMT

I want to find that if the value ot1 > ot2 let count Employeeid in each department.

MayilVahanan — Tue, 16 May 2023 05:52:33 GMT

Dim: Department
Exp: Sum(Aggr(If(OT1 exp > OT2 exp, 1), EmployeeId, Department))

Paknanarn23 — Wed, 17 May 2023 02:29:59 GMT

And if I want a condition that ot1 < ot2 count Employeeid in each department. what do I need to do?

Paknanarn23 — Wed, 17 May 2023 02:40:49 GMT

where the number of employees that is total column 2 combined with column 4 must be equal to the number of column 1

MayilVahanan — Wed, 17 May 2023 06:39:46 GMT

Can you send the sample data with expected output

hic — Wed, 17 May 2023 07:31:43 GMT

I would use

Count({<EmployeeId={"=OT1>OT2"}>} distinct EmployeeId)

This assumes that each employee only has one value of OT1 and one value of OT2. If there are several, you need to use e.g.

Count({<EmployeeId={"=Sum(OT1)>Sum(OT2)"}>} distinct EmployeeId)