DOS command to Export a Table from QlikView QVF

[Qliksol]

Howdy,

I have a chart in a QVF that is updated each week.  I would like to run a DOS command to export the data to a CSV file.

I've read quite a few posts, but I'm not seeing anything like this.  Is it possible?

Thanks!

[JandreKillianRIC]

Hi @Qliksol 

I got the solution for you without doing a reload. 

The Document Tigger that you added for post reload - Just change this to OnOpen. See below 

Here is the new .bat file - You will see there is a 30 second wait time - This will allow for the application to open and the macro to run. Adjust this if needed. 

@echo off
REM Start the QlikView application and get its Process ID (PID)
start "" "c:\Program Files\QlikView\QV.exe" "C:\Users\Jandr\OneDrive\Desktop\Test.qvf"
for /f "tokens=2" %%a in ('tasklist /fi "imagename eq QV.exe" /fo list ^| findstr "PID:"') do set PID=%%a

REM Wait for 30 seconds
timeout /t 10 /nobreak >nul

REM Close the specific instance of QV.exe using its PID
taskkill /pid %PID% /f

This .bat file will open the QVF - Run the macro using the trigger and then close the application. 

Please let me know if this is the solution you where looking for. 

Regards - Jandre