Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. April 17 - 20, 2023, in Las Vegas! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
shiveshsingh
Master
Master

Automate Qlikview Excel Report via Email

Hello Guys

 

Please help in automating Qlikview Excel Report via Email.

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

 

5 Replies
Frank_Hartmann
Master II
Master II

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
Partner - Creator III
Partner - Creator III

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
Master
Master
Author

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
Partner - Champion III
Partner - Champion III

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
Master
Master
Author

Perfect, let me give it  a try 🙂