email alert notification

[Anonymous]

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%

[giovanneb]

Hi, I think this can help.

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

Regards

[Anonymous]

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

Thanks

[neelamsaroha157]

Try this -

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

Or if % doesn't work try it with 0.30

[Anonymous]

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

[balabhaskarqlik]

Post the expression you used in bar chart.

[balabhaskarqlik]

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

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

[neelamsaroha157]

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.

[Anonymous]

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

Round(ELAPSEDRUNSECSJR/60)/100

Thanks

[balabhaskarqlik]

Condition:

=Round(ELAPSEDRUNSECSJR/60)/100 > 0.33

Message:

=’Bar percentage increased of ‘

& Round(ELAPSEDRUNSECSJR/60)/100 - 0.25

& '%'

Events - On Post reload.