topic Re: Count in QlikView

Count

gautik92 — Fri, 04 Sep 2015 09:20:22 GMT

I have a scenario where some employees have latitude values and some dont have

I want to count the employees who have latitude values and count of employees who dont have

tresB — Fri, 04 Sep 2015 09:26:54 GMT

Try like:

Count({<latitude={'*'}>} Distinct Employees) -->Employess with latitude values

Count({$- <latitude ={'*'}>} Distinct Employees) -->Employess without latitude values

Or,

Count(Distinct Employees) - Count({<latitude={'*'}>} Distinct Employees)

Note: This works If 'no latitude values' means null.

gautik92 — Fri, 04 Sep 2015 09:32:56 GMT

Hi tresesco,

without latitude not working

Kushal_Chawda — Fri, 04 Sep 2015 09:33:18 GMT

try

Count({<latitude={"=len(trim(latitude))>0"}>} Distinct Employees) -->Employess with latitude values

Count({<latitude ={"=len(trim(latitude))=0"}>} Distinct Employees) -->Employess without latitude values

tresB — Fri, 04 Sep 2015 09:34:35 GMT

Perhaps they are not really null. Could you attach a sample qvw ?

gautik92 — Fri, 04 Sep 2015 09:36:47 GMT

values from database

tresB — Fri, 04 Sep 2015 09:40:11 GMT

Did you try like: Count({$- <latitude ={'*'}>} Distinct Employees)

gautik92 — Fri, 04 Sep 2015 09:55:06 GMT

got it thanks