topic Re: Urgent need help on sending Qlikview reports in any exported format to users Email. in QlikView

Urgent need help on sending Qlikview reports in any exported format to users Email.

Anonymous — Wed, 19 Sep 2012 13:41:41 GMT

Hi All, right know i got a requirement from our users that i need to export data in the either pdf of excel or any other presentable format and send that information to their Emails on a scduled basis . Can that option is available in Qlikview . If that is available how can we do that. Any help on this is greatly appreciated.

Thanks,

Vinay

Re: Urgent need help on sending Qlikview reports in any exported format to users Email.

Wed, 19 Sep 2012 13:56:13 GMT

If the title bar of graphics has xl option to export data to Excel.

I hope to help you.

Re: Urgent need help on sending Qlikview reports in any exported format to users Email.

Anonymous — Wed, 19 Sep 2012 14:36:03 GMT

Hi Gregoria, thank you for your response i know the that option. but my issue is that data needs to be exported automatically and Email distribution also should be taken care by Qlikview itself.

Re: Urgent need help on sending Qlikview reports in any exported format to users Email.

Wed, 19 Sep 2012 14:38:45 GMT

You can use a macro similar to this one. However this one is not set up to automatically run, so you would need to add that.

Re: Urgent need help on sending Qlikview reports in any exported format to users Email.

Wed, 19 Sep 2012 14:39:26 GMT

Sorry for my answer, look that http://community.qlik.com/thread/56007

Re: Urgent need help on sending Qlikview reports in any exported format to users Email.

chris_johnson — Wed, 19 Sep 2012 14:43:29 GMT

Hi,

QlikView can do this but you will need QlikView Publisher and the PDF Report Distribution as well as the QlikView Server itself.

If you just have the server there is a product called NPrinting (disclosure - we are a UK partner!) which is an add-on to QlikView and can schedule email distribution of both PDF and Excel. Go to www.nprinting.com to download a trial if you wish. You will be able to locate local partners there also who can help.

Also, if you search the forums you will likely find other people creating macros to send emails of QlikView reports out although you'd need to do a bit of work to sort that out and maintain it yourself.

Regards,

Chris

Re: Urgent need help on sending Qlikview reports in any exported format to users Email.

Anonymous — Wed, 19 Sep 2012 14:52:09 GMT

Hi Rebecca, thank you for your response. another question i have is how can we automate the exporting and sending that information in the form of Email. For easy purpose i have attached a sample document which as a straight table . how can i export that table information with the macro and automate that process can you please help me with that...

Re: Urgent need help on sending Qlikview reports in any exported format to users Email.

Wed, 19 Sep 2012 15:20:17 GMT

Here is your example set up for you to enter the email addresses. I have not automated mine before (I just use a button) but I imagine you can use the Document Triggers to schedule the macro to run or build it into the macro code itself. Sorry I am not much help with that, but hopefully this will be a start for you.

Re: Urgent need help on sending Qlikview reports in any exported format to users Email.

Wed, 19 Sep 2012 15:21:25 GMT

Also, make sure you select 'Allow any Macros' upon opening and also select the following under Tools > Edit Module:

Re: Urgent need help on sending Qlikview reports in any exported format to users Email.

Anonymous — Wed, 19 Sep 2012 17:30:33 GMT

Hi Rebecca thank you for your help on this. Quick question i have is when i open this application in my qlikview desktop and enter email in the Email input box and then when i click on the button (Email report) it is opening the macro code. Please let me know if i am missing anything.

Re: Urgent need help on sending Qlikview reports in any exported format to users Email.

Wed, 19 Sep 2012 17:32:25 GMT

First thing is to check the security (see above post). Second is to check that the path is valid. I have it set to save as an Excel file in C:\temp, but you can adjust that as needed.

Re: Urgent need help on sending Qlikview reports in any exported format to users Email.

Wed, 19 Sep 2012 17:33:52 GMT

Do you use Outlook?

Re: Urgent need help on sending Qlikview reports in any exported format to users Email.

Anonymous — Wed, 19 Sep 2012 17:37:32 GMT

yes we are using outlook. and i have checked the secuity and set up the you asked me too.

Re: Urgent need help on sending Qlikview reports in any exported format to users Email.

Wed, 19 Sep 2012 17:46:10 GMT

Try the following: On Tools > Edit Module > Select 'Test' and let me know what the error message says in the top.

Error Message will look like this (see highlighted):

Re: Urgent need help on sending Qlikview reports in any exported format to users Email.

Anonymous — Wed, 19 Sep 2012 17:49:34 GMT

Please see the error which i am getting. Thanks for your help.

Re: Urgent need help on sending Qlikview reports in any exported format to users Email.

Wed, 19 Sep 2012 17:54:01 GMT

Looks like the problem is with your path. Change your path to something you know is valid and try to run it again.

Re: Urgent need help on sending Qlikview reports in any exported format to users Email.

Anonymous — Wed, 19 Sep 2012 18:02:21 GMT

that is working perfect . Now last thing lets say of i have to enter more EMails how can i do that in my input box is there any way i can do that.

Re: Urgent need help on sending Qlikview reports in any exported format to users Email.

Wed, 19 Sep 2012 18:08:40 GMT

Enter the email addresses separated by a semi-colon. For example:

email1@mail.com; email2@mail.com; email3@mail.com

Re: Urgent need help on sending Qlikview reports in any exported format to users Email.

Anonymous — Wed, 19 Sep 2012 18:12:46 GMT

Will this macro works in AJAX mode or only in IE plug in . Sorry for asking you more questions.

Re: Urgent need help on sending Qlikview reports in any exported format to users Email.

Wed, 19 Sep 2012 18:14:19 GMT

I'm not sure about AJAX (never used it), but it works in IE plug in as long as the user selects 'Allow any macro' when they get set up.