Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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)