topic Re: email alert notification in QlikView

email alert notification

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Please help with the calculation on the conditions

How to send an email alert notification based on data changes

On reload or open, I want to send an email notification only the jobs that exceeded 30%

Re: email alert notification

giovanneb — Thu, 30 Aug 2018 13:48:43 GMT

Hi, I think this can help.

CREATING AUTOMATED ALERTS AND EMAILS SENDING BASED ON DATA LOADED IN QLIKVIEW.docx

Regards

Re: email alert notification

Anonymous — Thu, 30 Aug 2018 14:20:12 GMT

Hi , Please help on the calculation condition , I am struggling on how to get only the jobs that exceeded 30%

Thanks

Re: email alert notification

neelamsaroha157 — Thu, 30 Aug 2018 14:22:18 GMT

Try this -

If(YourChartExpression> '30%', 1,0)

Or if % doesn't work try it with 0.30

Re: email alert notification

Anonymous — Thu, 30 Aug 2018 14:34:02 GMT

does not work the way I want , How do I get only the jobs that exceeded the 30 percent, Please send an example

Re: email alert notification

BalaBhaskar_Qlik — Thu, 30 Aug 2018 15:38:02 GMT

Post the expression you used in bar chart.

Re: email alert notification

BalaBhaskar_Qlik — Thu, 30 Aug 2018 15:46:29 GMT

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

Add your expression in message box, add other required data.

Re: email alert notification

neelamsaroha157 — Thu, 30 Aug 2018 17:27:24 GMT

the above expression was for the 'condition' which evaluates whether to send out the alert or not. if you want the list of jobsnames which are greater 30%, then in the message and/or description you need to provide the calculation, something like -

If(YourChartExpression> '30%', concat(jobsnames,',')

with other hard coded string as message.

Please share some sample for specific output.

Re: email alert notification

Anonymous — Fri, 31 Aug 2018 04:10:37 GMT

Hi Please see the expression I sued in the bar char.

Round(ELAPSEDRUNSECSJR/60)/100

Thanks

Re: email alert notification

BalaBhaskar_Qlik — Fri, 31 Aug 2018 07:02:13 GMT

Condition:

=Round(ELAPSEDRUNSECSJR/60)/100 > 0.33

Message:

=’Bar percentage increased of ‘

& Round(ELAPSEDRUNSECSJR/60)/100 - 0.25

& '%'

Events - On Post reload.