Extracr in CSV format

[padmanabhan_ram]

Hi All,

In a table with more that one lack of records, i know it is not possible to export to excel by a user from access point.

I want to know are there any other option available in QlikView.

Is it possible by the user to export the table in csv format from Access point without using any buttons.

Pleas let me know if there are any ways to achieve this.

Thanks and Regards,

Padmanabhan

[pljsoftware]

Hi Padmanabhan,

always you need to press a button to export data. If you want only a CSV without enter in Qlikview maybe you haven't to use Qlikview but write a procedure for export your data in CSV.

If you want to use macro you can use function ServerSideExportEx

set tb = ActiveDocument.GetSheetObject("CH01")

tb.ServerSideExportEx "C:\test.xml" , ";" , 3 '0=HTML, 1=Text, 2=Bitmap, 3=XML, 4=QVD, 5=BIFF

or use a event on button and select action type External and action Export.

Regards

Luca Jonathan Panetta

www.pljsoftware.com

[padmanabhan_ram]

Thanks Luca Jonathan Panetta,

as we know the export to excel icon appears in the table, do we have any similar icon for csv.

Thanks,

Padmanbahan

[rajeshvaswani77]

Create a button or an icon for this.

Also when huge data is exported it will write many sheets in excel if excel 2013 is installed.

On the other hand, You can consider writing this CSV by a job, if you know what's needed.

Imagine, you select something and then the parameters are recorded, next an edx is triggered.

thanks,

Rajesh Vaswani