Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 :(.
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
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