topic Question on ALERTS.... in QlikView

Question on ALERTS....

hopkinsc — Tue, 31 Aug 2010 12:39:36 GMT

Hi, Can anyone tell me if QLIKVIEW can send automatic alerts on a reload ?

We have an Transaction application which reports on transaction from 250+ retail stores. Each store sends in data files automatically at the end of each night. The qlikview app then performs an automatic reload at 5am. When the data is loaded into the app, i would like alerts to go out to specific people informing them of any 'Problems'

e.g.

multiple refunds in the same transaction
refunds over a certain value
large cash variances, etc.

Can this be done?

Question on ALERTS....

Tue, 31 Aug 2010 12:54:03 GMT

Hi,

Email / Alert can be sent from Qlikview. You need to creat a VB Script function by defining to whom are all you want to send email and map the same function after the reload in Document setting under trigger tab.

This will do the job for you.

- Sridhar

Question on ALERTS....

johnw — Wed, 01 Sep 2010 00:01:03 GMT

You don't necessarily need any VB script. I've only just yesterday built my first email alert, so I don't guarantee that this is right, but here's an example intended to email a fixed list of recipients if there's a particular data problem. The mail recipients can also be an expression, so could be loaded from a database into a QlikView table, and then concatenated from there, or however you want to source the email list.

Question on ALERTS....

Wed, 01 Sep 2010 03:18:40 GMT

When the Qlikview document is run through the Qlikview server it is interesting to note (while it makes sense and is expected) that the mail settings on the Qlikview server (QMC - Qlikview Server Settings -> SMTP/ QEMC System -> Setup -> Mail server) override the Qlikview desktop client mail settings (Settings - User Preferences - Mail).

Cool feature. I hadn't looked it until now either.

Question on ALERTS....

johnw — Wed, 01 Sep 2010 18:16:52 GMT

I agree that it makes sense, but it WAS a little confusing. I noticed the email settings in the user preferences, but assumed that they wouldn't be associated with the document. I don't control the servers, but I assumed there was something set up on them to handle email. So I crossed my fingers and installed it, hoping that I was right about what configuration would be used and that the servers were configured correctly. Turns out it worked.

Edit: Also, if I'd known that email alerts were THIS easy, I'd probably have had a lot more of them by now. It doesn't even need to be a user alert. It could be something to just let me know if one of my applications is looking a little funny. Hmmm.

Question on ALERTS....

montubhardwaj — Wed, 01 Sep 2010 20:55:30 GMT

Hi John,

I also need to have this functionality of sending mails automatically. But I am not sure about the setting /configuration. aif possible, let me know the process how to make it work.

many thanks in advance.

Regards,

Sharma

Question on ALERTS....

johnw — Thu, 02 Sep 2010 00:53:02 GMT

I'm not sure what you're asking. I showed an example above. As for what the various fields you configure and write expressions for mean and do, you can search for "alerts" in the help. If you mean how you get there, it's Tools -> Alerts. Or if you want, Tools -> Alert Wizard, and it will (I assume) guide you through the process. If you mean how to configure the server itself, I don't know. I didn't and can't configure our server.

Question on ALERTS....

montubhardwaj — Thu, 02 Sep 2010 07:31:09 GMT

Thank you John. I got the required information. Your previous was very helpful.

Thanks much.

Regards,

Sharma

Question on ALERTS....

Thu, 23 Sep 2010 13:12:52 GMT

Did you do something extra to make the email adress from QMC/QEMC override the client mail setting?

Whenever I open an application using IE plugin, the server address i empty. Tried changing the address in the console, but the address at the client keeps being empty.

Any ideas?

Question on ALERTS....

Mon, 15 Aug 2011 08:51:20 GMT

Hi jensfpk,

I am also experiencing similar problem. On QV Plugin for IE, when I configure the tab User Preferences > Mail, I am able to send email notification via alerts.

Obviously, I don't want to configure it for each user, so I have configured the mail server via QEMC (test: Ok), but when I empty my tab User Preferences > Mail, somehow it does not get the setting definied in the QEMC, and when an alert is triggered, the dialog User Preferences gets opened, and no email is sent.

Have you managed to fix it?

On the QEMC > System > Mail Server, What is the meaning of the tab Folder Access? In the Reference Manual, it says: "On this tab you add the names of the document administrators that are allowed to distribute via e-mail." As for now, this tab remains empty for me.

Thanks in advance,