Len() in Set Analysis

[wanyunyang]

Hi guys,

If I want to sum up all the sales amount with blank category, how should I write the expression with set analysis? Should be something like:

SUM({<LEN(Category)=0>}Amount)

Thanks in advance!

[sunny_talwar]

Do you have an id field which uniquely identify your data? Like OrderID? If you do, then try this

Sum({<OrderID = {"=Len(Trim(Category)) = 0"}>} Amount)

[vpanchuda]

I also have a similar issue 

I have a table in my dashboard with Dimensions as below and I Need to count blanks in Action Plan Dimension and show it in a Actions not planned 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