Comparing two fields - counting condition

[sbeaty]

Hello there. In need of some help here, pretty new to Qlik and would appreciate any help! Thank you in advance 😊

I am trying to figure out how I can compare these two fields to calculate where we are lacking servicers in each zip code.

For example,

Field A: Has a count of all claims by zip code

Field B: Has a count of all servicers by zip code

I want to get a count of when there's a claim in a zip code where we don't have a servicer in that zip code to repair. 

What would that expression be?

[stevejoyce · Accepted solution]

How about this...

Count (distinct {<[Field A] = {">0"} , [Field B] = {"=0"} >} [zip code])