Show multiple values in one cell (like current selections object)

[pepe2209]

Hello

I am trying to make my own 'current selections' overview with standard table graph (I don't want to use the standard current selections object)

please look at example

Data:

ID	Value1	Value
123	3	A
123	3	B
123	4	C
123	4	D

And I want this 'current selections' table:

ID('s)	Value1('s)	Value2('s)
123	3,4	A, B, C, D

It's easy when after selection only one value remains but is it also possible to show multiple values separated with comma?

your help would be much appreciated.

Regards Peter

[martinpohl · Accepted solution]

see attached

hope that's it

Regards

[dirk_konings]

you could use the Concat function

Dirk

[#4]

try this

=CONCAT({<Value1=>} DISTINCT Value1,',')

similarly

=CONCAT({<Value=>} DISTINCT Value,',')

[#5]

concat(Distinct value,',')

[jagan]

Hi,

Try like this

In Straight table take ID as Dimension

Use Concat(DISTINCT Value1) as expression1

and

Use Concat(DISTINCT Value2) as expression2

Hope this helps you.

Regards,

Jagan.

[er_mohit]

Dim ID

Try in expression side

concat( distinct Value1,', ') //for Value1

add 2nd expression

concat( distinct Value2,', ')  //for Value2

or you can try this on script also copy and paste this code

T1:

LOAD  * Inline [

ID, Value1, Value2

123, 3, A

123, 3, B

123, 4, C

123, 4, D

];

LOAD Concat(DISTINCT Value1,',') as New1,

Concat(DISTINCT Value2,',') as New2,

ID

Resident T1

Group by ID;

DROP Table T1;

Reload it

hope it helps

[ashwanin]

Concat (DISTINCT Value1 ,',')  in expression 1

and Concat (DISTINCT Value ,',') in Expression 2