Count with conditions

nbazz — Wed, 22 Dec 2021 15:42:54 GMT

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.

Re: Count with conditions

stevejoyce — Thu, 30 Sep 2021 14:54:12 GMT

Try this:

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

topic Re: Count with conditions in App Development

Count with conditions

Re: Count with conditions