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