Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Take a look at the post Generating AND, OR , NOT selection logic in Qlik Sense by @JonnyPoole. Its five years old, but still good.
Take a look at the post Generating AND, OR , NOT selection logic in Qlik Sense by @JonnyPoole. Its five years old, but still good.
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