Null count in straight table

clondono — Thu, 03 Mar 2016 20:55:46 GMT

Hello,

I’m trying to get a COUNT of DISTINCT Projects with Tasks missing Facility Name.

I can get then listed correctly in the “Task Missing Facility Name” table using this expression:

=if(len(trim(TASK_FACILITY))=0, '**UNASSIGNED**', TASK_FACILITY)

It puts the **UNASSIGNED** text for TASK-FACILITY for all tasks missing the facility name.

The issue is when I try to “count” the number of projects with tasks missing facility names.

I’m using this formula:

Count(DISTINCT{$<Flag_NullTaskSeq = {"=NullCount(TASK_FACILITY)>0"}>}REQUEST_ID)

Which seems to work fine, but for some strange reason it doesn’t return the correct value for some PMs.

For example, no filters applied the PM listed below (D) is showing 1 project missing facility name ( which it is not correct). If I select D as the responsible PM it changes to 0 which is the correct value.

Any ideas how to handle these null counts?

Thanks!

Message was edited by: Carlos Londono I'm including a sample file with 3 tables, the 2 upper tables return the correct results. When I combine the fields in the lower table (to export to NPrinting for a Pivot chart) one of the fields returns the wrong count. Any ideas on how to solve this issue? Thanks!

Re: Null count in straight table

sunny_talwar — Thu, 03 Mar 2016 21:42:01 GMT

What happens if you use this:

Count(DISTINCT{$<Flag_NullTaskSeq = {"=Len(Trim((TASK_FACILITY))>0"}>}REQUEST_ID)

Re: Null count in straight table

clondono — Thu, 03 Mar 2016 21:54:49 GMT

Sunny using the expression you suggested returns zero for all counts

Re: Null count in straight table

Anonymous — Thu, 03 Mar 2016 22:56:19 GMT

The Aggr() function may well help.

topic Re: Null count in straight table in QlikView

Null count in straight table

Re: Null count in straight table

Re: Null count in straight table

Re: Null count in straight table