Possible values

[gireesh1216]

Hello Team,

I have three fields in below table like ID,S_ID and M_ID.

IF I select ID =10 in list box , I want output in text object like 4,5,10

IF I select ID =11 in list box , I want output in text object like 4,5,6,10

I have data like below:

Load * inline [

ID,S_ID,M_ID

1,4,7

2,5,8

3,6,9

4,10,11

5,10,11

6,10,11

10, ,11

11,

];

Thanks

Gireesh

[shiveshsingh]

The value which you want to display in textbox is S_ID??

[ruanhaese]

Try the CONCAT function

=concat(ID,'-')

[gireesh1216]

Not working..

If I select 10 in ID filter, I want 4,5,6 output

[ruanhaese]

Not sure why yours doesnt work.

Just loaded your table in to the editor and added a listbox and a text object with the Concat

[gireesh1216]

Nooo..This is normal condition.

Your selected S_ID filter.I don't want this filter.

Use ID filter and select 10 ..I WANT SAME RESULTS LIKE ABOVE.

[gireesh1216 · Accepted solution]

Finally got solution:

this expression working fine:

=Concat({1<M_SID=p(ID)>}SID,',')