Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

email alert notification

Notifications.PNGNotificationnns.PNG

 

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%

9 Replies
Highlighted
Creator II
Creator II

Re: email alert notification

Highlighted
Contributor II
Contributor II

Re: email alert notification

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

Thanks

Highlighted
Specialist II
Specialist II

Re: email alert notification

Try this -

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

Or if % doesn't work try it with 0.30

Highlighted
Contributor II
Contributor II

Re: email alert notification

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

Highlighted

Re: email alert notification

Post the expression you used in bar chart.

Highlighted

Re: email alert notification

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

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

Highlighted
Specialist II
Specialist II

Re: email alert notification

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.

Highlighted
Contributor II
Contributor II

Re: email alert notification

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

Round(ELAPSEDRUNSECSJR/60)/100

Thanks

Highlighted

Re: email alert notification

Condition:

=Round(ELAPSEDRUNSECSJR/60)/100 > 0.33

Message:

=’Bar percentage increased of ‘

& Round(ELAPSEDRUNSECSJR/60)/100 - 0.25

& '%'

Events - On Post reload.