how exporting Chart's Data to .csv or txt file?

[#1]

Hi All,

I have a problem with exporting Chart's data to csv or text file... I am working in telecom industry and i have a qlikview file that contain 600 million of data... and in that i create a chart's(straight table) ... users can filter some field and then the result will show in charts... the maximum number of data than can be show in table is 66 million record... i want user can export the chart's data in csv or text file but i cant...

Regards

Sahar

[its_anandrjs]

NO, If you having problem for exporting huge data from chart then you can export or save it as use of STORE command and then do filtering and analysis on the exported csv file. But if you want filtered data from the chart then you can use export it as CSV and XLS but your system need good ram for this and it takes time for this also because first rows fetch and then it saved to particular file.

I suggest if you make the File Maker from the QV application and then export this file as a CSV or XlS this will save your time also.

Regards

[Joseph_Musekura]

Hi

I tested below sample code by loading/exporting  both 1million and 10 million rows.

*I have office 2010 / RAM 8GB

* I tested Export  >> save as txt /csv,  export to Excel etc..

I was able to export 1 million rows but when used 10 million I stopped the action after 13 minutes no response in both case above.  I think it is a limitation on Excel and txt, CSV side (third part limitations)

Any other observations?

T1:
load RowNo(), RowNo()*4, RowNo()/4
AutoGenerate 10000000;

//alternative test for 1 million

//AutoGenerate 1000000;

[#4]

Thanx Joseph

i dont think there is a limitation in .txt file.. i receive txt file with more than 500,000,000 record... i think qlikview maybe cant handle export large amount of data

[Joseph_Musekura]

Thanks,

You are correct, txt file may not be concerned as it is for Excel . Check this similar discussion. They ponted out some tips.

http://community.qlik.com/message/437979#437979

Regards,

[suepenick]

Creating a Macro:

Tools

Edit Module

Create a subroutine:

   Sub ExportMyFile

   Set Obj = ActiveDocument.GetSheetObject("CH01")    

   Obj.exportex "\\MyDocuments\MyFile.csv",1

   End Sub

The chart number in the general tab foes in the sheet object above

Module Security and Current Local Security needs to be set to System Access

Then you have to add the name of the Export sub  routine to your document triggers

Settings

Document Properties

Triggers

OnPostReload

Users can select what data they want, then click reload and a CSV file will be written to the path.

the issue I see may be that you may need more memory to process 60million records "in Memory"