help with filter

[beck_bakytbek]

Hi Folks,

i have the following situation:

my table does look like:

id	name	value	text
1	test1	10	aa
2	test2	20	aaa
3	test3	30	aaaa
4	test1	40	b
5	test2	50	bb
6	test3	60	bbb
7	test1	70	c
8	test2	80	cc
9	test3	90	ccc
10	test1	100	cccc

i tried to implement this expression : Only({<name = {"test1"}>}text), but it does not work

my expected output is field: text: aa, b,c,cccc

i know i can solve this issue in script by clausel where name = 'test1', but i want to know, whether is possible within a chart: pivot, straightable.

Thanks a lot for any and all help

Beck

[surendraj]

could you try with..

sum({<name = {"test1"}>}value)

[Aurelien_Martinez]

Hi,

Concat(Distinct {<name = {"test1"}>} text, ', ')

[beck_bakytbek]

Hi Surenda,

i tried, but it does not work, i want see only text with values: aa, b,c,cccc on the base of name = test1

do you have any idea?

Beck

[CarlosAMonroy]

or you can try:

If(name = 'test1',only(text))

[beck_bakytbek]

Hi Martines,

thanks for your feedback, but it does not work

[beck_bakytbek]

Hi Carlos, thanks a lot for your feedback

but the same, it does not work

[Kushal_Chawda]

this expression should work

Concat(Distinct {<name = {"test1"}>} text, ', ')

Please share the sample data and expected output need

[CarlosAMonroy · Accepted solution]

Hi, it does work!

Please see image below: I used the data you posted on Inline table and use a straight table to show the results.

[beck_bakytbek]

Thanks a lot Carlos,

i misplaced a charakter , thanks a lot for your help