Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
trishita
Creator III
Creator III

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? 

3 Replies
qlikmeplease
Creator III
Creator III

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.

trishita
Creator III
Creator III
Author

so there is no job scheduler within qlikview?

qlikmeplease
Creator III
Creator III

No unfortunately not.  Will have to make use of a task scheduler.