Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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.