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

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
StavrosMcGillicuddy
Contributor
Contributor

How can I use OR logic

I have a products table and a Company table.

I need to count the companies that have any of the selected products. ("Product 1" or "Product 2" or "Product 3")

I thought about using a table chart but the default logic there is all  (must have "Product 1" and "Product 2" and "Product 3")

1 Reply
Saravanan_Desingh

Try something like this,

Count(DISTINCT If(WildMatch(Products,'Product 1','Product 2','Product 3'),Companies))