Count Blank and show in KPI

[vpanchuda]

I have a table with Dimensions as below and I Need to count blank in Action Plan Dimension and show it in a KPI, Can someone help me with Syntax, I am new to QLik Sense.

Please note it's blank it's NOT (---)

Target date	Responsible Rep	Action Plan
01-12-2019		Renew
02-12-2019	AJ	Swap
03-12-2019	RM
04-12-2019	AJ
05-12-2019
06-12-2019	VS	Renew
07-12-2019		Close
08-12-2019	VS	Close

[tresesco]

Try like:
=Count(if(len(trim([Action Plan]))=0,[Action Plan])

[Mauritz_SA]

Hi there

I am not sure whether counting the [Action Plan] field will yield any results as you cannot count Null/Blank values. What you could try doing is counting the Target Dates where the Action Plan is Null (Length without spaces is 0). Try this: Count({<[Target date] = {"=Len(Trim([Action Plan]))=0"}>} [Target date])

If you want to use @tresesco  's formula you can use:

=Count(if(len(trim([Action Plan]))=0,[Target date]))

Regards,

Mauritz

[tresesco]

---

@Mauritz_SA wrote:

Hi there

.....you cannot count Null/Blank values...

Mauritz

---

Actually you can count real NULLs, using NullCount()

[formosasol]

NullCount - script function

NullCount() returns the number of NULL values aggregated in the expression, as defined by a group by clause.

Syntax: NullCount ( [ distinct ] expr)

[Mauritz_SA]

Hi @tresesco 

That's true, I was referring to the Count function - I guess capitalisation on my side would have made that clear.

@vpanchuda I just checked and you can use NullCount([Action Plan]) as a measure if they are real Nulls.

Regards,

Mauritz

[vpanchuda]

It shows '0' as result , actually the cells are not filled (if the cells are left empty in the table are they real Nulls or Blank values??) i assume its blank values , if its blank is there any possible way to count it?

[Mauritz_SA]

The way I understand it, if there are blank values in the source table (or after a join) then they are real Nulls. I think it would be best to share a sample app 🙂