Transform variable content into chart diagram

[hugmarcel]

Hi 
I have a variable vList with content: 
'A;B;C;D¬1;2;3:4¬5;6:7;8' 
I want to display the content of vList in a diagram with A,B,C,D as Dimension members ("column headers") and numbers values below ("formulas"😞 
A B C D 
1 2 3 4
5 6 7 8
How Can I achieve this without using of script?
Thank you and regards! Marcel

[marcus_sommer]

You could use a straight-table with a calculated dimension like:

=valuelist(1,2,3)

which visibility is hidden as well as totals and column-header are disabled.

As one of your four expression you might use something like this:

=Pick(rowno(total),
  $(y(x, 1, 1)),
  $(y(x, 2, 1)),
  $(y(x, 3, 1)))

and y is defined like:

subfield(subfield($1, '¬', $2), ';', $3)

and it results in:

- Marcus

[hugmarcel]

Thank you, great!

I have experimented using value_list as well, but did not manage to pass the values to the formula expressions!

It looks like you have implemented this in a qvw, is it possible to get the qvw?

Thx a lot! Marcel

[marcus_sommer · Accepted solution]

Here it is.