3 Replies Latest reply: Jul 10, 2017 12:41 AM by Kumar Velagiram RSS

    automatic export of data from a QVW

      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
          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  
           set obj = ActiveDocument.GetSheetObject("CH01")
           obj.Export (output_dir & Filename) , "|"
          end sub
          • Re: automatic export of data from a QVW
            Kumar Velagiram

            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
              Kumar Velagiram

              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.