Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
BTIZAG_OA
Creator
Creator

Instersect values from field

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 :(. 

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

 

 

View solution in original post

1 Reply
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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