Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vpanchuda
Contributor III
Contributor III

Count Blank Cells

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 RepAction Plan
01-12-2019 Renew
02-12-2019AJSwap
03-12-2019RM 
04-12-2019AJ 
05-12-2019  
06-12-2019VSRenew
07-12-2019 Close
08-12-2019VSClose
Labels (1)
8 Replies
santhiqlik
Creator
Creator

Hi,

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

Vegar
MVP
MVP

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
Contributor III
Contributor III
Author

I have tried this , it gives 0
vpanchuda
Contributor III
Contributor III
Author

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
MVP
MVP

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
Creator
Creator

Can you share sample qvf

Vegar
MVP
MVP

vpanchuda
Contributor III
Contributor III
Author

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. 😞