QlikView App: Send Data In QlikView Alerts

[stevedark]

This example has been produced to accompany the blog post Sending Data In QlikView Alerts

There is a Qlik Sense version of this solution here: https://www.quickintelligence.co.uk/send-data-from-qlik-load-script/

This application demonstrates how alerts e-mails can be sent when a certain criteria is met.  It also takes this concept further by showing how the CONCAT and AGGR statements can be used to construct a string from a number of expressions, which can then be used as the body of the email.

The blog article gives further details and explanation on how this works and how to implement it in your own applications.

Please also see my other uploaded Qlik apps and tutorials https://www.quickintelligence.co.uk/examples/

Steve Dark

https://www.quickintelligence.co.uk/

[ecolomer]

Good work

Thank's for sharing

[stevedark]

Thanks Enrique - glad you like it.

[kkkumar82]

Thanks steve,

You made things easy.

Kiran kumar

[hugo_andrade]

Nice document. Thanks!

[beck_bakytbek]

As always Steve,

very helpful  and understandable

thanks for sharing

[hareeshkumar_gv]

Hi Steve,

I created the alerts and click the Batch check box. Where we have to the server smtp mail set up?

[stevedark]

Hi Hareesh,

When using Batch it uses the QMC SMTP settings - the exact same ones that are used to send alerts when reloads fail.  If you see the QMC failure alerts then you should be good to get QlikView alerts.

Steve

[hareeshkumar_gv]

Thanks Steve.  Please help on my requirement.
We have one requirement that sending an task failure alerts of a dashboard using a self subscribing emails.

We are the owners of server. we are working as a shared services. our server is using different development teams. We have to send the dashboard task failure alerts to.the owners of dashboard development teams.
Development team A dashboard task failure alerts.sends to only team A. we have to send the alerts by dynamically changing/adding email recipients.
Note: All of Development teams is not having email groups.

How we can do this in Qlikview..

[stevedark]

Hi Hareesh,

The recipient list for emails can be read from a variable, just put something like $(vRecipients) in the recipients box.

This variable can be set in the load script, how you go about this will depend on how the subscription method works.  If you get addresses in a simple database table it would be something like;

Recipients:

SQL SELECT

     Address

FROM dbo.ApplicationAlerts

WHERE Application = 'My Application'

;

let vRecipients = '';

for i = 0 to NoOfRows('Recipients') -1

let vRecipients = vRecipients & if(i > 0, ',', '');

let vRecipients = vRecipients & peek('Address', i, 'Recipients');

next

DROP TABLE Recipients;

Hope that helps.

[hareeshkumar_gv]

Hi Steve,

I am able to send the Alert mails using Alerts option in qlikview desktop and using the QMC mail smtp details. But When the task fails, the Alerts mails are not sending. Please suggest how I can achieve this. Thanks!!