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