Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Community,
I have a QlikView file that I use to extract and manipulate data coming form an external database (in Jade).
I then export 3 charts on my model into 3 different .csv files. To speed up the process, I've set up 3 buttons that do that, but I have to open the file and manually click on the buttons... Can I automatize that?
The script is reloaded automatically daily to refresh the data.
Is there a way to work with 'Triggers' so that I can automatize the export process? I've tried a trigger connected to Post Reload, but it doesn't seem to work.
Thanks and Regards,
Cristina
you need not create straight tables or chart, you can directly use the store command
Store Field1, Field2, Field3 From File into Filename.CSV(txt);
create a batch file command
"C:\Program Files\QlikView\Qv.exe" /r File.qvw
and schedule this using windows scheduler
hope this helps
you need not create straight tables or chart, you can directly use the store command
Store Field1, Field2, Field3 From File into Filename.CSV(txt);
create a batch file command
"C:\Program Files\QlikView\Qv.exe" /r File.qvw
and schedule this using windows scheduler
hope this helps
Try to give the action you gave to button in trigger->on open.
so that once we open the dashboard automatically it will export
Thank you very much for your help, Venkita.
I am testing the task running the batch file and I think with some fine tuning I'll get what I need.
Regards,
Cristina
Yes, I had tried that, but that works as long as I have to task to actually open the model.
Still playing with it.
Thanks and regards,
Cristina
Apologies Venkita,
Another question: is there a batch command that will only open the .qvw file?
Thanks and Regards,
Cristina
"C:\Program Files\QlikView\Qv.exe" File.Qvw
Thank you very much.
That does the trick.
I have:
- a batch file that opens a .qvw
- the .qvw file runs a few tasks triggered on open, including closing the file.
BUT! both QlikView and the cmd screen remain open. When/if I close QlikView then the cmd screen closes as well.
Is there any way to get the both apps to close on conclusion of the batch file?
NOTE: the "STORE into ... " script works for a few other extractions I do, but in this case, the output file is the result of some pivoting.... I find it's easier to do it exporting a chart so that I can check what the chart is showing and exporting as there are other processes running after mine...
Thanks so much!
An alternate option would be to write a vbs file to do all the job and call it via batchfile
I have created a test file.
1. AutomationTestVBS.qvw
2. Test.VBS
3. Test.bat
Copy all the files to a folder called TMP
Edit the Test.VBS file in notepad change the path statement to point to the folder created.
save the file
run the batch file and that will invoke the vb script and the vb script will generate the excel file out of the pivot table.
Hope this helps