Set up email automatically delivery in Qlikview

[#1]

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.

[#2]

Anyone has idea?

[suniljain]

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.

[#4]

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. 

[Anonymous]

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.

[#6]

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.

[Anonymous]

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.

[#8]

HI Johannes,

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

[suniljain · Accepted solution]

PFA od two application,Qlikview

1) Create PPT In Qlikview

2) Send Attachment From Qlikview.

Hope this will resolve your issue.

[#10]

The 2nd attachment is not opening