topic Export chart value into .CSV file with type comma delimited using macro in QlikView

Export chart value into .CSV file with type comma delimited using macro

jeevays7 — Thu, 12 Oct 2017 15:11:30 GMT

Hi all,

I need to export a table chart value into a .CSV file by using macro.

The CVS file type should be Comma delimited.

How can we export like this?

I have attached sample .CSV file.

Anil_Babu_Samineni — Thu, 12 Oct 2017 15:27:37 GMT

Perhaps this?

SUB EXPORT

set sObject1 = ActiveDocument.GetSheetObject("CH01")

sObject1.Export "C:\Users\Anil\Qlikview\MyDoc.csv", ", "

end sub

its_anandrjs — Thu, 12 Oct 2017 15:30:50 GMT

Check this attached thread

jeevays7 — Fri, 13 Oct 2017 06:06:26 GMT

Hi Anil,

It is saved as .CSV and save as type is "unicode text". but i need the save as type in "CSV(Comma delimited)".

Anonymous — Mon, 23 Oct 2017 10:38:37 GMT

Hi Jeeva,

Anonymous — Tue, 24 Oct 2017 08:46:22 GMT

Hi Jeeva,

Here i have Enclosed Comma Delimited Pure CSV Export Using Macro