Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
trishita
Contributor 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
Highlighted
qlikmeplease
Contributor III

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.

trishita
Contributor III

Re: How to generate excel dynamically from qlikview report on weekly basis

so there is no job scheduler within qlikview?

qlikmeplease
Contributor III

Re: How to generate excel dynamically from qlikview report on weekly basis

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