Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
smanas
Contributor III
Contributor III

AND and OR in expression

Hi, I'm trying to get IDs with certain Zip codes (123,456,789,1234,9876) and claim codes (0011,2234,4435) or CPT codes (98675,96745,90876,89765)

 

Basically, I need IDs with all zip codes but either of the claim codes or CPT codes.

 

Please advise thank you. 

Labels (2)
1 Reply
Gabbar
Specialist
Specialist

Uses as measure:-

Count({<ZIP_Code={123,456,789,1234,9876},Claim_Code={0011,2234,4435}>+<ZIP_Code={123,456,789,1234,9876},CPT_CODE={98675,96745,90876,89765}>}Id)