Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
smilingjohn
Specialist
Specialist

Empty Condition

Hi All , 

The below condiiton i used for set anaylsis gives me correct result .  ( in the below expression I was trying to show Either case_ID or TAX_ID should not be empty )  

 

count({<Dep={'Customs'},ID={"=Len(CASE_ID&TAX_ID)>0"}>}ID)

 

Now i want to show both case_ID and Tax_ID should be empty ,How can I change this expression accordingly ? 

 

Thanks in Advance 

1 Solution

Accepted Solutions
PriyankaShivhare
Creator II
Creator II

try this

count({<Dep={'Customs'},CASE_ID={"=Len(CASE_ID)=0"},TAX_ID={"=Len(TAX_ID)=0"}>}ID)

View solution in original post

2 Replies
Kushal_Chawda

@smilingjohn  try below

count({<Dep={'Customs'},CASE_ID={"=len(trim(CASE_ID))>0"},TAX_ID={"=len(trim(TAX_ID))>0"}>}ID)

PriyankaShivhare
Creator II
Creator II

try this

count({<Dep={'Customs'},CASE_ID={"=Len(CASE_ID)=0"},TAX_ID={"=Len(TAX_ID)=0"}>}ID)