Instersect values from field

[BTIZAG_OA]

Hello everyone,

i have users table and value table which is linked from id column.

on the table object its like this;

user1,value1

user1,value2

user2,value2

user2,value3

...

When i make selections from users column its reveal all possible values from value col. what i want to achieve is intersect of this values. 

example: i make selections user1 and user2, then i want to reveal common value for the selected users (in this example its value2).Sometimes users may shares more than 1 value or selections can made more than 2 user.

I tried GetFieldSelections() with match() but couldnt achieve the result :(. 

[rwunderlich · Accepted solution]

You want to show Values where the count of value is > 1.

Create a Table chart with:

Dimension: Value
Measure: Count({<Value={"=Count(Value)>1"}>}Value) 
Measure: Concat({<Value={"=Count(Value)>1"}>}DISTINCT User, ', ')  // Optional

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