Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
davidoxi
Contributor III
Contributor III

store crosstab in auto csv format

Hello
I have a crosstab in qlikview, and I want to retrieve it at each automotic telechrgement foramt csv and store in a specific folder .

5 Replies
Anonymous
Not applicable

Use Store command to save the table generated on a file of your system file.

Here you will find more information about that.

To save in csv, use:

STORE <table_name> INTO <file_name>.txt (ansi, txt, delimiter is ',')

davidoxi
Contributor III
Contributor III
Author

Thanks Felipe

but I want to store th crosstab chart like 'CH01' , 'TB5' ..

Anonymous
Not applicable

Can you post here a sample of your crosstab chart?

Anil_Babu_Samineni

Are you trying to get all object ID's??

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
davidoxi
Contributor III
Contributor III
Author

Hi

I created this macro :

SUB ExportChartToCSV

     SET  objChart = ActiveDocument.GetSheetObject("CH01")

     objChart.Export "test.csv", "; "

  

END SUB

I want run this macro  after script re-execution (Automati) .