topic Re: Filter value with AND association for one field in App Development

Filter value with AND association for one field

FernandaNava — Sat, 16 Nov 2024 01:09:36 GMT

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

Re: Filter value with AND association for one field

Vegar — Fri, 06 Nov 2020 17:39:24 GMT

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

Re: Filter value with AND association for one field

rwunderlich — Fri, 06 Nov 2020 17:43:11 GMT

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