topic Re: One alert per row in QlikView

One alert per row

salto — Mon, 31 Aug 2015 10:34:11 GMT

Hello,

I would like to send an alert to each email address in every record in a table, if a certain value of that same record meets a condition. Is this possible to do in QlikView?

Thanks in advance.

Re: One alert per row

maxgro — Mon, 31 Aug 2015 10:45:56 GMT

from what I understand it seems it's possible to add an expresion in the Mail Recipients of an Alert, like

=concat(MailAddress, ';')

and also add some set analysis to filter the recipients

Re: One alert per row

salto — Mon, 31 Aug 2015 11:10:07 GMT

Thanks Massimo, would your setting do the next?

Our table is:

email	Value
john@abc.net	20
mike@abc.net	35
bruce@abc.net	16
steve@abc.net	70

The Values should be between 15 and 20.

On reload, we need an email sent to John and other sent to Bruce, letting them know their Values.

Steve and Mike should not receive any message.

Is this possible? Thanks!

Re: One alert per row

maxgro — Mon, 31 Aug 2015 11:23:35 GMT

you have to try with this in Mail Recipients (an also all the other fields in Alerts window)

=concat({$ <Value={">=15<=20"}>} email, ';')

Re: One alert per row

stevedark — Thu, 14 Apr 2016 15:25:33 GMT

maxgro‌ 's solution is ideal for who to send to. If you want to send some data in the email then you may want to see this post:

http://www.quickintelligence.co.uk/qlikview-alerts/

Steve