topic Using a QV pivot chart object as datasource in another QV in QlikView

Using a QV pivot chart object as datasource in another QV

Thu, 14 Oct 2010 18:35:01 GMT

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.

Thanks

Glen

Using a QV pivot chart object as datasource in another QV

johnw — Thu, 14 Oct 2010 19:28:24 GMT

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.