Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
Not applicable

Count empty space in a column

Good Morning!

How do I count the "ISSUED" Status, when in the Delayed column has the field blank. In this case the count is "6".

8 Replies
tajmohamed30
Contributor III

Re: Count empty space in a column

Hi,

Have you tried this,

=count(IsNull(Delayed)) or

=NullCount(Delayed)

Thanks

Taj Mohamed

felipedl
Valued Contributor III

Re: Count empty space in a column

You could use set analysis to count the ones that don't have value.

Like this:

count({<Delayed={""}>}Status)


Regards,

Felipe.

Not applicable

Re: Count empty space in a column

Good morning!

Did not work. I need you to count nulls in the Delayed column, only when the Status column has the ISSUED option

Status

Delayed

ISSUED

ISSUED

SAFETY

ISSUED

INPRG

ISSUED

ISSUED

CUSTOMER

ISSUED

ISSUED

MATERIAL

ISSUED

MATERIAL

ISSUED

MATERIAL

ISSUED

SAFETY

ISSUED

CUSTOMER

ISSUED

MATERIAL

ISSUED

MATERIAL

ISSUED

MATERIAL

ISSUED

MATERIAL

ISSUED

MATERIAL

ISSUED

MATERIAL

ISSUED

CUSTOMER

ISSUED

MATERIAL

Not applicable

Re: Count empty space in a column

Good morning!

Did not work. I need you to count nulls in the Delayed column, only when the Status column has the ISSUED option

Status

Delayed

ISSUED

ISSUED

SAFETY

ISSUED

INPRG

ISSUED

ISSUED

CUSTOMER

ISSUED

ISSUED

MATERIAL

ISSUED

MATERIAL

ISSUED

MATERIAL

ISSUED

SAFETY

ISSUED

CUSTOMER

ISSUED

MATERIAL

ISSUED

MATERIAL

ISSUED

MATERIAL

ISSUED

MATERIAL

ISSUED

MATERIAL

ISSUED

MATERIAL

ISSUED

CUSTOMER

ISSUED

MATERIAL

felipedl
Valued Contributor III

Re: Count empty space in a column

Just add another clause to the set analysis.

count({<Status={"ISSUED"},Delayed={""}>}Status)


Regards,

Felipe.

Not applicable

Re: Count empty space in a column

Did not work! Counting with this expression gives "Zero"

felipedl
Valued Contributor III

Re: Count empty space in a column

Hi, attached a QVW with an example

Hope it helps.

Felipe.

ahaahaaha
Honored Contributor

Re: Count empty space in a column

Hi,

May be like this (look attached file)

RangeSum(Above(Count({<Delayed={"=Len(Delayed)=0"}>}Delayed), 0, ROWNO(TOTAL)))


Regards,

Andrey