Solved: export csv - Qlik Community - 1172686

Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.

Skip to main content

Qlik.com | Qlik Services | Qlik Help

Ask a Question

I use the following macro to export to csv

SET objChart = ActiveDocument.GetSheetObject("CH461")

objChart.Export "G:\SuiviRupture\Rupture.csv", ""

I need to get the following results

but I got the following results

How to modify the script ?

1 Solution

Accepted Solutions

Hi,

you should use the second parameter of the export function, please try like this:

SET objChart = ActiveDocument.GetSheetObject("CH461")

objChart.Export "G:\SuiviRupture\Rupture.csv", ";"

Let me know if this helps.

Kind regards,

View solution in original post

3 Replies

Same problem? Export to csv without delimiter

Hi,

you should use the second parameter of the export function, please try like this:

SET objChart = ActiveDocument.GetSheetObject("CH461")

objChart.Export "G:\SuiviRupture\Rupture.csv", ";"

Let me know if this helps.

Kind regards,

Author

Awesome! Many thanks