topic How to generate excel dynamically from qlikview report on weekly basis in QlikView https://community.qlik.com/t5/QlikView/How-to-generate-excel-dynamically-from-qlikview-report-on-weekly/m-p/141268#M753409 <HTML><HEAD></HEAD><BODY><P>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?&nbsp; </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT trishita 2020-11-25T16:16:04Z How to generate excel dynamically from qlikview report on weekly basis https://community.qlik.com/t5/QlikView/How-to-generate-excel-dynamically-from-qlikview-report-on-weekly/m-p/141268#M753409 <HTML><HEAD></HEAD><BODY><P>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?&nbsp; </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-generate-excel-dynamically-from-qlikview-report-on-weekly/m-p/141268#M753409 trishita 2020-11-25T16:16:04Z Re: How to generate excel dynamically from qlikview report on weekly basis https://community.qlik.com/t5/QlikView/How-to-generate-excel-dynamically-from-qlikview-report-on-weekly/m-p/141269#M753410 <HTML><HEAD></HEAD><BODY><P>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.&nbsp; Please keep in mind this will be quite the process, but it can be done.</P><P></P><P>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.</P></BODY></HTML> Tue, 09 Oct 2018 09:53:41 GMT https://community.qlik.com/t5/QlikView/How-to-generate-excel-dynamically-from-qlikview-report-on-weekly/m-p/141269#M753410 Anonymous 2018-10-09T09:53:41Z Re: How to generate excel dynamically from qlikview report on weekly basis https://community.qlik.com/t5/QlikView/How-to-generate-excel-dynamically-from-qlikview-report-on-weekly/m-p/141270#M753411 <HTML><HEAD></HEAD><BODY><P>so there is no job scheduler within qlikview? </P></BODY></HTML> Tue, 09 Oct 2018 10:22:17 GMT https://community.qlik.com/t5/QlikView/How-to-generate-excel-dynamically-from-qlikview-report-on-weekly/m-p/141270#M753411 trishita 2018-10-09T10:22:17Z Re: How to generate excel dynamically from qlikview report on weekly basis https://community.qlik.com/t5/QlikView/How-to-generate-excel-dynamically-from-qlikview-report-on-weekly/m-p/141271#M753412 <HTML><HEAD></HEAD><BODY><P>No unfortunately not.&nbsp; Will have to make use of a task scheduler.</P></BODY></HTML> Tue, 09 Oct 2018 10:54:07 GMT https://community.qlik.com/t5/QlikView/How-to-generate-excel-dynamically-from-qlikview-report-on-weekly/m-p/141271#M753412 Anonymous 2018-10-09T10:54:07Z