Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try this:
count({<User = p({<Action = {'A'} >} User) * p({<Action = {'B'} >} User) > } User)