Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Here it is.
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
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
Here it is.