Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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)