Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
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
Partner
Partner

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])

 

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
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
Partner
Partner

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
Plees ekskuse my Swenglish and or Norweglish spelling misstakes
santhiqlik
Creator
Creator

Can you share sample qvf

Vegar
Partner
Partner

image.png

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
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. 😞