Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
My_Rebecca
Creator
Creator

How to calculate with criteria of blank item?

 count({<[Customer Complaint_On-time/Late]={'On-time'},[Customer Complaint_Location]={'SLC SZ'},len([Customer Complaint_Forwarder Name])=0>}[Customer Complaint_On-time/Late])

 

how to correct this expression? I only want to calculate when the column of "Forwarder Name" is blank, the count of On-time/Late, thanks.

 

My_Rebecca_0-1693295643987.png

 

Datasource:

My_Rebecca_1-1693295683963.png

 

Labels (1)
7 Replies
BrunPierre
Partner - Master
Partner - Master

Try

[Customer Complaint_Forwarder Name]={"=Len(Trim([Customer Complaint_Forwarder Name]))=0"}

My_Rebecca
Creator
Creator
Author

@BrunPierre sorry, the result is not correct.

could you please have more look on this question?

My_Rebecca
Creator
Creator
Author

Is there anyone who could help me? thanks.

BrunPierre
Partner - Master
Partner - Master

Post the data in a flat file and the anticipated output in that case.

zhaofeng
Partner - Creator
Partner - Creator

Try this

 count({<[Customer Complaint_On-time/Late]={'On-time'},[Customer Complaint_Location]={'SLC SZ'},[Customer Complaint_Forwarder Name]={''}>}[Customer Complaint_On-time/Late])

My_Rebecca
Creator
Creator
Author

@zhaofeng I have tried before, like in Excel, but it doesn't work.

My_Rebecca
Creator
Creator
Author

@BrunPierre dear, I have solved in another way, thanks.