# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for
Did you mean:
Highlighted
Contributor II

## Using P() with multiple criteria

Is it possible to use P() to show a set that has multiple criteria in the formula? In my case looking for customers that each purchase all three products. I do not want in this group customers that only purchase 1 or 2 products. Only customers have purchase all three.

Sum({\$<CustomerName=P({1<Product={'1016'},{'2016'},{'1032'}>}CustomerName)>}(Qty))

1 Solution

Accepted Solutions
MVP

Or this

Sum({\$<CustomerName = {"=Count(DISTINCT {<Product = {'1016', '2016', '1032'}>} Product) = 3"}>} Qty)

3 Replies
Highlighted
MVP

May be this

Sum({\$<CustomerName=P({1<Product={'1016'}>})*P({1<Product={'2016'}>})*P({1<Product={'1032'}>})>}(Qty))

MVP

Or this

Sum({\$<CustomerName = {"=Count(DISTINCT {<Product = {'1016', '2016', '1032'}>} Product) = 3"}>} Qty)

Highlighted
Contributor II

Thanks Sunny. This is exactly what I was hoping for.