Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
padmanabhan_ram
Creator II
Creator II

Extracr in CSV format

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

3 Replies
pljsoftware
Creator III
Creator III

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
Creator II
Creator II
Author

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
Specialist III
Specialist III

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