Count Blank Cells

[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

[santhiqlik]

Hi,

Please try using NullCount function... Nullcount([Action Plan])

[Vegar]

set NullInterpret =''; //To get correct null intepretation from inline table
LOAD * INLINE [
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];

Then use RangeNullCount() to count null values.

=RangeNullCount([Responsible Rep])

=RangeNullCount([Action Plan])

[vpanchuda]

I have tried this , it gives 0

[vpanchuda]

Data gets Loaded in the script from a folder , i have the dimensions as a table in my dashboard ,I have to show the missing number of Action plan in a KPI hence i have to create an expression in KPI object.
i have tried with =RangeNullCount([Action Plan]), gives 1 always

[Vegar]

Is the value NULL()? If you are able to select it in a value list then it is not null then you could do something like this.

=sum(len([Action Plan])=0)*-1

[santhiqlik]

Can you share sample qvf

[Vegar]

[vpanchuda]

Jag förstod inte..

Thanks but Sorry, I did not understand the solution, I only need one KPI that counts blank cells to show record to the Manager how many have no Actions planned. 😞