topic Re: how exporting Chart's Data to .csv or txt file? in QlikView

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

Sat, 24 May 2014 04:36:47 GMT

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

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

its_anandrjs — Sat, 24 May 2014 06:21:23 GMT

Right click on your straight chart >> then use Export option >> then select csv or txt save as type >> and then save file as your appropriate save option.

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

Sat, 24 May 2014 06:28:47 GMT

Thanx ..but this is not working,,, i have 60 million record in charts and this way is not working and qv file goes to not responding status ... i think maybe some macro will be help me... by the way Thanx:)

Regards

Sahar

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

Joseph_Musekura — Sat, 24 May 2014 06:35:31 GMT

Hi,

You can also click (see below) to export to excel.

Check the format of your data before exporting to ensure that you have expected format in Excel

Regards,

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

its_anandrjs — Sat, 24 May 2014 06:37:20 GMT

If data is huge as you say is about the 60 million records then i believe you have to use the STORE function in the load script and export the table as csv format see the sample script for that

RawSource:

Load * From Location;

STORE RawSource into RawSource.csv(txt);

This will store your data as csv file and then any one do analysis on this file. Macro is the option but i believe there is also it takes time and may be error also.

Regards

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

Joseph_Musekura — Sat, 24 May 2014 06:39:52 GMT

Sorry!!

Thank you for this additional info.

How about the resources i.e. RAM (memory for example)?

Did you test with less than 60m (for example limit the load to 10m and test)?

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

Joseph_Musekura — Sat, 24 May 2014 06:42:42 GMT

Hi,

I just found this web site:

http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP005199291.aspx

This could help to understand the issue

Thanks

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

Sat, 24 May 2014 06:56:37 GMT

thanx ..

you mean that i cant export large amount of data directly from charts, because user in UI do some filtering on some dimension and then want to export data... what do you say is store all of data from script!

Regards

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

Sat, 24 May 2014 06:57:56 GMT

Hi Joseph

we have server with 128G ram... i cant even export 10 million:(

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

Joseph_Musekura — Sat, 24 May 2014 07:08:06 GMT

Hi,

The above article shows a limitation for earlier Excel versions vs office 2010.

is this your case?

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

its_anandrjs — Sat, 24 May 2014 07:10:13 GMT

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

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

Joseph_Musekura — Sat, 24 May 2014 08:10:08 GMT

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;

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

Sat, 24 May 2014 09:38:02 GMT

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

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

Joseph_Musekura — Sat, 24 May 2014 09:48:33 GMT

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,

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

suepenick — Mon, 30 Mar 2015 16:08:19 GMT

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"