Automate Qlikview Excel Report via Email

[shiveshsingh]

Hello Guys

Please help in automating Qlikview Excel Report via Email.

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

[Frank_Hartmann]

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?

[pgrenier]

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

[shiveshsingh]

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?

[petter]

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.

[shiveshsingh]

Perfect, let me give it  a try 🙂