Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Export in CSV with colons or semicolons

Hi everyone !

We are working with both French users and English users, and we are looking for a solution to let the client choose the separators (colon or semicolon) when exporting datas into a csv file.

As we are working with the AJAX, is there any solution without using macros?

thanks

1 Reply
Highlighted
Partner
Partner

Re: Export in CSV with colons or semicolons

Hi, This maybe work:

Sub ServerExportExcolon

Set st = ActiveDocument.GetSheetObject("LB01")

st.ServerSideExportEx "C:\test.csv", ":" ,1,850

End Sub

Sub ServerExportExsemicolon

Set st = ActiveDocument.GetSheetObject("LB01")

st.ServerSideExportEx "C:\test.csv", ";" ,1,850

End Sub

Try to connect them to a button by cal the macro in action.

BR//GOnza