Concatenated string variable as Dimension

[cedriclupo]

Hello,

i am working on a project and i come cross a problem that i cannot solve in the front end.

I have in a variable a concatenated string, values separated by comas.

I want to use this field as a dimension (e.g. listbox). The treeview seemed the easiest, however it's not expanded by default.

Do you have any other possibility?

Thank you a lot

Cedric

[tresesco]

Is script an option? If so, use SubField(). Otherwise you can get a listbox from the string using a complex expression in the front end but that would not respond to selection in associative nature.

[cedriclupo]

Hey tresesco, thanks for your answer,

script is not an option as it's calculated dynamically and changed few times before the next reload

We don't try to select in this dimension, but just to look what the user chose. So no selection, read only.

[MK_QSL]

Can you explain little more with an example?

[tresesco · Accepted solution]

May be like attached sample

[cedriclupo]

Thanks that's exactly what I was looking for!! Great

Now the extra question : i want to simulate a selection or mark a specific value in that box.

for example: Variable x: A,B,C (in the listbox we just created)

                    variable z: B

I want to color or mark something next to B as variable Z equals a value of the variable x.

Is it something possible or are we looking too far?