topic Re: Extracr in CSV format in QlikView

Extracr in CSV format

padmanabhan_ram — Thu, 11 Dec 2014 10:22:19 GMT

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

Re: Extracr in CSV format

pljsoftware — Thu, 11 Dec 2014 10:46:22 GMT

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

Re: Extracr in CSV format

padmanabhan_ram — Thu, 11 Dec 2014 11:10:38 GMT

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

Re: Extracr in CSV format

rajeshvaswani77 — Thu, 11 Dec 2014 11:18:33 GMT

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