Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
How about this...
Count (distinct {<[Field A] = {">0"} , [Field B] = {"=0"} >} [zip code])
How about this...
Count (distinct {<[Field A] = {">0"} , [Field B] = {"=0"} >} [zip code])