topic Re: Export QlikView Straight table data into .csv format on automated process in QlikView

Export QlikView Straight table data into .csv format on automated process

datashaw — Mon, 26 Jan 2026 18:19:17 GMT

Hello Experts,

I'm looking to export a QlikView object data into .csv file into C:\Users\' on daily automated process .

appreciate your suggestions.

thanks,

Re: Export QlikView Straight table data into .csv format on automated process

andrey_krylov — Fri, 24 Aug 2018 06:26:10 GMT

In the Load script at the end of the tables write

STORE TableName into TableName.csv(txt);

Re: Export QlikView Straight table data into .csv format on automated process

puttemans — Fri, 24 Aug 2018 07:53:27 GMT

Hi Praveen,

As Andrey mentions, best is to (re-)create the object as a table in your script, and then save this table into a csv on the desired place. Every time you reload the application/the script (which you can define on the QV-server), the file in the destination folder will be renewed.

Re: Export QlikView Straight table data into .csv format on automated process

datashaw — Fri, 24 Aug 2018 12:08:52 GMT

Hi Johan,

Thank you for the reply. Can you please send an example to 'Recreate the QlikView Straight table object in script' (My strait table contains 1 Dimension and two Calculated set analysis expressions )

So i can store as .csv file.

appreciate your help.

Re: Export QlikView Straight table data into .csv format on automated process

datashaw — Fri, 24 Aug 2018 12:11:36 GMT

Hi Andrey,

I am not sure ..Is this something like this..?

Store "CH66" into $(vQVDFilesFolderPath)FTPData.csv (txt);

PS: CH66 is my straight table Object ID and it contain two calculated expressions.

Re: Export QlikView Straight table data into .csv format on automated process

BalaBhaskar_Qlik — Fri, 24 Aug 2018 17:14:30 GMT

May be check this:

Export objects to CSV using macros in Load script

Re: Export QlikView Straight table data into .csv format on automated process

BalaBhaskar_Qlik — Fri, 24 Aug 2018 17:15:18 GMT

May be this:

1. write a macro that will export charts/table boxes to text file. you can create the charts or table boxes on a hidden tab, if you do not want the qv document users to see these charts designed just for exporting.

2. configure the OnPostReLoad trigger (found in document properties - triggers) to fire the macro.

3.use a batch file to reload the qvw (using the command-line reload syntax). use windows task scheduler to schedule the batch file to run on a schedule.

since Publisher will not fire any macro code within a qlikview document, you must use the batch file reload process in order for the macro to fire.

below is an example macro. this will export data in the object CH01 to a pipe-delimited text file.

'--------------------------
' Export QC Chart Routine
'-------------------------
sub ExportChart
output_dir="C:\export\"
Filename="DataFile.txt"
set obj = ActiveDocument.GetSheetObject("CH01")
obj.Export (output_dir & Filename) , "|"
end sub

automatic export of data from a QVW