Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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) .