topic Re: Concatenated string variable as Dimension in QlikView

Concatenated string variable as Dimension

cedriclupo — Tue, 17 Jun 2014 07:28:03 GMT

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

Re: Concatenated string variable as Dimension

tresB — Tue, 17 Jun 2014 07:36:28 GMT

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.

Re: Concatenated string variable as Dimension

cedriclupo — Tue, 17 Jun 2014 07:41:25 GMT

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.

Re: Concatenated string variable as Dimension

MK_QSL — Tue, 17 Jun 2014 07:52:46 GMT

Can you explain little more with an example?

Re: Re: Concatenated string variable as Dimension

tresB — Tue, 17 Jun 2014 08:18:28 GMT

May be like attached sample

Re: Concatenated string variable as Dimension

cedriclupo — Tue, 17 Jun 2014 08:38:58 GMT

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?