topic Expression logic help please in QlikView

Expression logic help please

Fri, 22 Jan 2016 13:59:23 GMT

I have a excel file as below

Here the logic I have to get in a single expression is ,

1.1.If Room type is WRKST and OFFICE then count only the Employees with the email attached (Don’t count the Empname with blank)

2.If room Type is anything else other than OFFICE and WRKST then count employees with name and the blank fields too.

The issue I am facing is I am counting the Employee name twice.Any help is appreciated.

Thank you.

sunny_talwar — Fri, 22 Jan 2016 14:11:49 GMT

Can your provide the data in an excel format with the expected output.

Peter_Cammaert — Fri, 22 Jan 2016 14:31:43 GMT

Expression 1:

=count({<[RM RoomType]={'WRKST', 'OFFICE'}, [EM EmployeeName]={"=len(trim([EM EmployeeName]))>0"}>} [RM BuildingCo])

Expression 2:

=count({<[RM RoomType] -= {'WRKST', 'OFFICE'}>} [RM BuildingCo])

Fri, 22 Jan 2016 14:36:18 GMT

Not sure how to attach the file here,so created a new thread ..sorry and above is the link to find the excel ifle.Thank you very much

Peter_Cammaert — Fri, 22 Jan 2016 14:39:13 GMT

To attach a file to a post, click "Use Advanced Editor" in the top right, and in the editor select "Attach" on the bottom right.