topic Question about configuring alarms in QlikView

Question about configuring alarms

Tue, 23 Jun 2009 15:02:54 GMT

Hi All,

I would like to configure an alert when the status for records has changed after reload. This seems to work well for numeric conditions but I can not make it work for a text field. I was playing with a condition where I count the 'Closed' status but this dose not work as well.

This is the configuration of the alert:

The 'Trigger Level' has been set to State Changes. I assume that the problem is related to the fact that there can be multiple occasions of a status change between reloads. How to resolve this?

Thanks for your help.

Question about configuring alarms

Wed, 24 Jun 2009 20:55:33 GMT

Hi, anyone an idea? Thanks for your help.

Question about configuring alarms

rwunderlich — Thu, 25 Jun 2009 02:35:21 GMT

The condition will only work if Ticket_List.Status only contains one value. Does it have only a single value?

If the field can have multiple values and you want to fire when one of the values is "Closed", try:

sum(if(Ticket_List.Status ='Closed',1))>0

-Rob

Question about configuring alarms

Thu, 25 Jun 2009 14:46:59 GMT

Thanks Rob, it works.

Question about configuring alarms

Sun, 05 Jun 2011 18:22:02 GMT

Hi Rob,

Is it possbile to send an image on an email by using info(photofieldname) via Alerts function?