Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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.

Thanks

Glen

1 Reply
johnw
Champion III
Champion III

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.