topic Re: Logic help Please in QlikView

Logic help Please

Fri, 22 Jan 2016 14:35:18 GMT

Please find attached file

Re: Logic help Please

ThornOfCrowns — Fri, 22 Jan 2016 14:38:16 GMT

Is this the same query as:

Expression logic help please

If so, please try to keep your replies or additional comments to the same thread as it makes it easier to follow.

Thanks.

Re: Logic help Please

sunny_talwar — Fri, 22 Jan 2016 14:41:17 GMT

Try this:

=Count({<[RM RoomType] = {'WRKST', 'OFFICE'}, [EM EmployeeName] = {"=Len(Trim([EM EmployeeName])) > 0"}>} [EM EmployeeName]) + Count({<[RM RoomType] -= {'WRKST', 'OFFICE'}>} [RM RoomType])

Re: Logic help Please

MK_QSL — Fri, 22 Jan 2016 14:48:33 GMT

=Count(

{

<[RM RoomType] = {'WRKST', 'OFFICE'}, [EM EmployeeName] = {"=Len(Trim([EM EmployeeName])) > 0"}>

<[RM RoomType] -= {'WRKST', 'OFFICE'}>

}

[RM RoomType])

Re: Logic help Please

Fri, 22 Jan 2016 15:30:13 GMT

Thank you.This did magic

Re: Logic help Please

Fri, 22 Jan 2016 15:30:34 GMT

Thank you.Yopur logic was very helpful.