Filter value with AND association for one field

[FernandaNava]

I want to know if there is a way to select values for one column which are associated with two values in another. Example:

User	Code
1	27
1	68
2	27
3	68
4	55
4	32
5	27
5	68
5	23
6	14
7	78

Here I would like to see the users associated with code 27 AND code 68. When doing this selection Ishould only get users 1 and 5, but not 2 or 3 because they're associated with only one of the codes.

Any ideas on how to do this?

Thank you

[Vegar · Accepted solution]

Take a look at the post Generating AND, OR , NOT selection logic in Qlik Sense by @JonnyPoole. Its five years old, but still good. 

[rwunderlich]

For a chart with Dimension of User, use a Measure like:

count({<User={"=count(Distinct Code) = GetSelectedCount(Code)"}>}Code)

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com