Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Don't miss the upcoming Q&A with Qlik session on Qlik Application Automation on November 16th! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sbeaty
Contributor II
Contributor II

Comparing two fields - counting condition

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?

1 Solution

Accepted Solutions
stevejoyce
Creator III
Creator III

How about this...

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

View solution in original post

1 Reply
stevejoyce
Creator III
Creator III

How about this...

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

View solution in original post