Count with conditions

[nbazz]

Hello,

My data on Qlik Sense is structured as follows:

Date	User	Action
2021-09-30	Ana	A
2021-09-30	Ana	B
2021-09-30	John	A
2021-09-30	Matt	B

I want to count all distinct users who did action A AND ALSO DID action B. Using the normal set analysis {<action={'A','B'}>} it returns to me all those who did action A and all those who did action B, not exclusively those who did both.

In the example above, the result of the count distinct should be 1, since Ana is the only one who did action A and action B both.

[stevejoyce]

Try this:

count({<User = p({<Action = {'A'} >} User) * p({<Action = {'B'} >} User) > } User)