Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Set up email automatically delivery in Qlikview

We want to set up automated delivery for some chart or straight table data. Who know how to set up in Qlikview? Do we need the publish license? Thanks a lot.

Tags (2)
1 Solution

Accepted Solutions
suniljain
Honored Contributor

Re: Set up email automatically delivery in Qlikview

PFA od two application,Qlikview

1) Create PPT In Qlikview

2) Send Attachment From Qlikview.

Hope this will resolve your issue.

9 Replies
Not applicable

Set up email automatically delivery in Qlikview

Anyone has idea?

suniljain
Honored Contributor

Set up email automatically delivery in Qlikview

you can email chart of qlikview application in following way .

1) export all required in excel or ppt.

2) you can email that Excel or PPT to all authorized user.

3) To send email you have to configure SMTP servers's details in macro.

4) you can schedule application according to your requirement.

Not applicable

Set up email automatically delivery in Qlikview

Hi Sunil,

    Thanks for your reply. But we want to setup it automatically. The big problem for your answer is how to automatically export to excel? If you have would you please give us any reference manual to check? Thanks. 

jsn
Honored Contributor

Set up email automatically delivery in Qlikview

Hi Stanley,

One approach would be to create automation using macros and VBscript code to distribute the information from a .qvw file but this might be a bit cumbersome. Another approach would be to use Publisher and possibly the PDF generator to distribute reports to users, whih does require additional licensing.

Not applicable

Set up email automatically delivery in Qlikview

Hi jsn,

    We don't have publish license so we will try to create marcos and VBScript code to distribute the information. Do you have sample code which can help us? Thanks.

jsn
Honored Contributor

Set up email automatically delivery in Qlikview

Try the community search engine and search for 'email macro' and you should find a bunch of posts discussing similar things and general macro development. Do be careful with macros though as they're not part of native QlikView functionality, can cause unexpected behavior in certain cases and might need tweaking when moving to new QlikView versions.

Not applicable

Set up email automatically delivery in Qlikview

HI Johannes,

   I get how to do that and thanks for your help.

suniljain
Honored Contributor

Re: Set up email automatically delivery in Qlikview

PFA od two application,Qlikview

1) Create PPT In Qlikview

2) Send Attachment From Qlikview.

Hope this will resolve your issue.

Not applicable

Set up email automatically delivery in Qlikview

The 2nd attachment is not opening