Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
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))