Instersect values from field

BTIZAG_OA — Fri, 26 Mar 2021 12:26:34 GMT

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

Re: Instersect values from field

rwunderlich — Fri, 26 Mar 2021 13:25:23 GMT

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

topic Instersect values from field in App Development

Instersect values from field

Re: Instersect values from field