topic Empty Condition in QlikView

Empty Condition

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Empty Condition

Kushal_Chawda — Tue, 27 Oct 2020 12:17:53 GMT

@smilingjohn try below

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

Re: Empty Condition

PriyankaShivhare — Tue, 27 Oct 2020 12:19:34 GMT

try this

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