How to generate excel dynamically from qlikview report on weekly basis
I want to generate an excel report from my qlikview application and store it in a specifc location in a shared drive.What could be an possible approach so that i dont have to manually download every time but it is automatically saved in the stored location or path.Should i use any job handler or trigger actions?
Re: How to generate excel dynamically from qlikview report on weekly basis
I have managed to do this before using MACRO's . Create a report within the QVW and then write a VBA script in order to export and save it to the network location. Please keep in mind this will be quite the process, but it can be done.
Generally speaking, I used to create a task in WINDOWS TASK SCHEDULER that opens a .bat file, that reloads the QVW and opens it, Then I had an ON OPEN event trigger that would start the MACRO to export and save the file.