I received several questions regarding my post Monitoring the Reload Schedule. Surprisingly the questions were not about the monitoring solution, but rather using Alerts. I’ll summarize the questions and answers here.
Can I loop through field values in an Alert?
Not directly. But you can create multiple alerts that use either bookmarks or set analysis in the Condition to handle a known set of field values. For example create one alert for Region=US and a second for Region=Europe and each sends an email to the associated Regional Manager.
Can I use an alert to always send an email?
Yes. Just set the Condition to “-1” (without quotes). This is always true and can be used to send text “mini-reports” to your email recipients. Your email text might be something simple like:
=’Currently open tickets: ‘ & sum(OpenTicketCounter)
Or something more complex like:
=’YTD Sales are ‘
& money(
sum({1
<[Invoice Year]={$(=year(today(2)))}>
}
Quantity * Price
)
, ‘$#,##0;($#,##0)’
)
& ‘
YTD Orders are ‘
& num(
sum({1
<[Order Year]={$(=year(today(2)))}>
}
Quantity
)
, ‘#,##0’
)
This will generate an email body that looks like:
YTD Sales are $12,014,788
YTD Orders are 167,580
You can build up complex expressions in a Text Object to get them correct and then paste to the Alert.
Can I include a chart image in an alert email?
No. If you know of a method, please leave a comment.
It may be helpful to include a url in the email that opens the Qlikview document for further analysis.
If you have Alert questions or tips, please leave a comment.
-Rob
I want to use macros for graphs and reports but I cant see the list of macros in latest version personal edition. Is there any way ?
Hi Rob, could i ask you about Alert in QV in html, is this possible and what would you recommend me ?
Thank you in advanced !
Iliana