topic Re: Email Alert in QlikView in QlikView

Email Alert in QlikView

Wed, 18 Jul 2012 02:00:41 GMT

Can someone tell me what needs to be done if I want to send out an email to users if they have exceeded limit on amount they can spend in a year. This should be an automated process every time you load data into QV app, as well as a report showing all the YTD spend.

Example: allowed annual spend amount is $100 for sales rep John and his YTD spend amount is $110. In this case, once you load the data, it should automatically send an email alert to John with allowed amount and actual spend amount, as well as a report showing all YTD spend.

Please suggest a best approach to achieve this without any user intervention (I.e. it should happen in background)

Thank you in advance.

Re: Email Alert in QlikView

Wed, 18 Jul 2012 04:14:18 GMT

You can write a macro to send mailer..Inputs for this you can get from API guide or other discussions in this forum

You can call this macro on option - On Post Reload available in QV11

Regards,

Priya

Re: Email Alert in QlikView

jvitantonio — Wed, 18 Jul 2012 08:05:50 GMT

Refer to: http://community.qlik.com/qlikviews/1068

Re: Email Alert in QlikView

Wed, 18 Jul 2012 11:29:39 GMT

Hi Sanjay, Firstly prepare a report according to your requirements and then go to reports tab and click on edit reports.. then drag and drop your required page... then you have to write a macro for sending that pdf report via mail but before all this we need to have a pdf tool(which is for qlikview) in order to generate your pdf... Hope this helps Regards gaurav Khare

Re: Email Alert in QlikView

Wed, 18 Jul 2012 11:55:41 GMT

Dear Sanjaygo,

Try the Alert Wizard under Tools to send e-mail when the specified condition is met.

It requires no manual intervention.

Hope this helps

Mhatim