Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
wanyunyang
Contributor II

Len() in Set Analysis

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!

2 Replies

Re: Len() in Set Analysis

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
New Contributor II

Re: Len() in Set Analysis

 

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