topic Re: store crosstab in auto csv format in QlikView

store crosstab in auto csv format

davidoxi — Wed, 25 Nov 2020 16:16:04 GMT

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 .

Anonymous — Tue, 21 Nov 2017 16:00:29 GMT

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 — Tue, 21 Nov 2017 17:57:19 GMT

Thanks Felipe

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

Anonymous — Tue, 21 Nov 2017 18:09:22 GMT

Can you post here a sample of your crosstab chart?

Anil_Babu_Samineni — Wed, 22 Nov 2017 06:01:08 GMT

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

davidoxi — Thu, 23 Nov 2017 09:26:07 GMT

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) .