topic Set Analysis Question in QlikView

Set Analysis Question

m_woolf — Fri, 25 Aug 2017 18:10:46 GMT

I have a chart where the dimensions are Department and MonthYr.

I need an expression that will count the Employees in each dept who have total workhours >0.

I have tried many things, but no joy.

Peter_Cammaert — Fri, 25 Aug 2017 18:18:58 GMT

Something like this?:

=sum(aggr(if (sum(WorkHours) > 0, 1), Employee, Department, MonthYr))

sunny_talwar — Fri, 25 Aug 2017 18:38:01 GMT

Another option would be to create a key in thr script...

LOAD Department,

MonthYr,

AutoNumber(Department&'|'&MonthYr) as Key

...

FROM ....

and then this

Sum({<Key = {"=Sum(WorkHours) > 0"}>}WorkHours)

effinty2112 — Sun, 27 Aug 2017 13:04:06 GMT

Hi M W,

Have you tried:

Count({$<Employee = {"=sum(workhours) > 0"}>}Employee)

Cheers

Andrew