Using a QV pivot chart object as datasource in another QV
Is it possible to create a Pivit Chart in one qvw and use as a datasource in another qvw?
I have a qvd list of data and I need to transform the structure.
Currently the structure of the list of data is period, statcode,amount. I need the new datasource to be period as a row, statcode as a column and amount being the value for every column.
Not possible. You could always export to Excel, and read in the Excel, but that's the wrong way to solve it. You should transform the structure in script, not in a chart. What you are describing sounds like a "generic load". Something like this:
GENERIC LOAD period ,statcode ,amount ...
Assuming I got my syntax right, that should convert the statcodes to field names, with the values currently specified in the amount field.
