Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
claude_jakob
Contributor III
Contributor III

How to export Line Chart data to Excel in readable format

Hi,

when I use export of a line chart showing 2 or more lines to clipboard/send-to-excel or other means my new table in excel is structured in a way I cannot easily rebuild the graph in excel. The reason is that the Qlikview export always export the x-axis data in one column and all y-axis data in one column.

How can I export the chart data that data from each line is exported to a separate column? Is this a matter of configuring in Qlikview or do I need makros?

I attached an example of the way data is exported to excel and the way I would need data in excel. Example taken from graph of one of the demo applications.

I greatly appreciate suggestions. Thanks,

Claude

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/0451.Chart_5F00_Export.xls:550:0]

0 Replies