Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

exporting table data to csv file

Hi ..

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

Thanks,

6 Replies
anbu1984
Master III
Master III

Store Table into Table.csv(Txt);

Anonymous
Not applicable
Author

Hi anbu..

Thanks for your reply..

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

ashfaq_haseeb
Champion III
Champion III

Try this

Data:

LOAD * INLINE [

CountryCode

ES

UK

US,

];

store Data into Data.csv(txt);

Regards

ASHFAQ

ashwanin
Specialist
Specialist

Hi Chandini,

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

anbu1984
Master III
Master III

Check this link

Export to CSV

ashfaq_haseeb
Champion III
Champion III

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