Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
FernandaNava
Partner - Contributor III
Partner - Contributor III

Filter value with AND association for one field

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

 

UserCode
127
168
227
368
455
432
527
568
523
614
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

Labels (1)
1 Solution

Accepted Solutions
Vegar
MVP
MVP

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

View solution in original post

2 Replies
Vegar
MVP
MVP

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
Partner Ambassador/MVP
Partner Ambassador/MVP

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