One alert per row

[salto]

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.

[maxgro]

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

[salto]

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!

[maxgro · Accepted solution]

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

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

[stevedark]

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