topic Re: Transform variable content into chart diagram in QlikView

Transform variable content into chart diagram

hugmarcel — Fri, 25 Jan 2019 10:22:16 GMT

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

Re: Transform variable content into chart diagram

marcus_sommer — Fri, 25 Jan 2019 12:23:02 GMT

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

Re: Transform variable content into chart diagram

hugmarcel — Fri, 25 Jan 2019 14:56:30 GMT

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

Re: Transform variable content into chart diagram

marcus_sommer — Fri, 25 Jan 2019 15:26:42 GMT

Here it is.