Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
vpanchuda
New Contributor

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
Contributor

Re: Count Blank Cells

Hi,

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

Partner
Partner

Re: Count Blank Cells

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

 

Please ekskuse my Norglish and Swenglish typos.
vpanchuda
New Contributor

Re: Count Blank Cells

I have tried this , it gives 0
vpanchuda
New Contributor

Re: Count Blank Cells

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

Re: Count Blank Cells

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
Please ekskuse my Norglish and Swenglish typos.
santhiqlik
Contributor

Re: Count Blank Cells

Can you share sample qvf

Partner
Partner

Re: Count Blank Cells

image.png

Please ekskuse my Norglish and Swenglish typos.
vpanchuda
New Contributor

Re: Count Blank Cells

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