topic Re: exporting table data to csv file in QlikView

exporting table data to csv file

Anonymous — Wed, 19 Nov 2014 06:42:51 GMT

Hi ..

Can any one help me how to export table data to csv file in Qlikview Script not in dashboard.

Thanks,

anbu1984 — Wed, 19 Nov 2014 06:44:46 GMT

Store Table into Table.csv(Txt);

Anonymous — Wed, 19 Nov 2014 06:49:20 GMT

Hi anbu..

Thanks for your reply..

Table means pivot or straight tables not a normal tables of script.

ashfaq_haseeb — Wed, 19 Nov 2014 06:52:53 GMT

Try this

Data:

LOAD * INLINE [

CountryCode

US,

];

store Data into Data.csv(txt);

Regards

ASHFAQ

ashwanin — Wed, 19 Nov 2014 06:54:40 GMT

Hi Chandini,

After reloading data into QlikView, Create Pivot or Straight Table. Your data will reflect into it.

anbu1984 — Wed, 19 Nov 2014 06:55:41 GMT

Check this link

ashfaq_haseeb — Wed, 19 Nov 2014 06:56:58 GMT

Hi,

Use this macro then

to export to avd

sub MyMacro
set obj = ActiveDocument.GetSheetObject("CH02")
obj.ExportEx "C:\test.qvd", 4
end sub

or to csv

sub ExportExcel
set obj = ActiveDocument.GetSheetObject("CH01")
obj.ExportBiff "C:\test.csv"
end sub

Let me know if that worked.

Regards

ASHFAQ