topic export csv in QlikView

export csv

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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 ?

Clever_Anjos — Mon, 30 May 2016 16:09:24 GMT

santiago_respane — Mon, 30 May 2016 16:14:09 GMT

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,

Anonymous — Mon, 30 May 2016 16:18:12 GMT

Awesome! Many thanks