topic Re: automatic export of data from a QVW in QlikView

automatic export of data from a QVW

Tue, 19 Jun 2012 07:21:02 GMT

i have a process that creates and daily reloads a QV model and publush it to the server.

i have another process, not using QV, but uses data calculated and stored in QV.

how can i create a batch file that will be scheduled to open the QVW and export the selected data?

the file type that will contain the exported data is of no importance. our ETL tools will handle everything....

Re: automatic export of data from a QVW

Tue, 19 Jun 2012 17:42:25 GMT

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

Re: automatic export of data from a QVW

Fri, 07 Jul 2017 09:46:26 GMT

automatic export of data from a Qvf

That means i want same option in qliksense why because i need to export daily basis

Re: automatic export of data from a QVW

Mon, 10 Jul 2017 04:41:16 GMT

Hi Tammy gibson,

i need same thing in qliksense not in qlkview ,

how to implement in qliksense Show me with the help of Screenshots.

Now we are using qliksense 3.2 version.

Thanks,

Kumar.V.

Re: automatic export of data from a QVW

Mon, 11 Sep 2017 21:11:43 GMT

This was really helpful.

It worked!

Kidane Asrat

Re: automatic export of data from a QVW

Hemanth458 — Tue, 04 Jun 2019 06:20:38 GMT

Its working fine when i Press test button.

But, It'n working when the task gets reloaded is there any other changes required to execute it.