topic Re: Automate Qlikview Excel Report via Email in QlikView

Automate Qlikview Excel Report via Email

shiveshsingh — Wed, 14 Nov 2018 09:57:48 GMT

Hello Guys

Please help in automating Qlikview Excel Report via Email.

Also can Visualizations can be sent via email in pdf form.

Re: Automate Qlikview Excel Report via Email

Frank_Hartmann — Wed, 14 Nov 2018 10:57:42 GMT

can u give mor infos?

Are you generating the excel by macro?

Do you want to use macro for email sending?

Did you try Reports Tab for generating PDF Output?

Re: Automate Qlikview Excel Report via Email

pgrenier — Wed, 14 Nov 2018 14:11:56 GMT

Hello Shiveshsingh,

In order to achieve this, you would need to either implement NPrinting, or alternatively use your QlikView app to extract your dataset to a .txt file, then use a third party solution such as SSIS+SSRS+Data Driven Subscription to create an excel grid and send it by email.

Regards,

Philippe

Re: Automate Qlikview Excel Report via Email

shiveshsingh — Thu, 15 Nov 2018 02:45:30 GMT

Yeah, I don't need pDF but excel format export of straight table.

Need to schedule the export daily, do i need macro for this?

Re: Automate Qlikview Excel Report via Email

petter — Thu, 15 Nov 2018 07:21:16 GMT

Yes you can do it with a QlikView macro. And the macro can be run by using Windows Task Scheduler to execute qv.exe (QlikView Desktop) daily with the /v switch to set a variable on start which can indicate to the QlikView app that you want a particular macro to be executed. You will have to set a macro to execute on open for the app. You will also have to make the macro close the app and exit qv.exe after the export.

Re: Automate Qlikview Excel Report via Email

shiveshsingh — Thu, 15 Nov 2018 07:23:34 GMT

Perfect, let me give it a try 🙂